Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: logon

Kerberos Configuration Manager for SQL Server

Don’t you just hate it when you once again have to look to Google for help on fixing some obscure Kerberos related authentication problem on SQL Server?

Luckily, I found a blog post about fixing Kerberos problems using a new tool from Microsoft, the Kerberos Configuration Manager for SQL Server. This tool will go through your settings and SPNs and what-not, to help you resolve the problem.

Published 2013-05-24
Categorized as Advanced, Tips Tagged authentication, kerberos, login, logon, spn, windows authentication

A short introduction to application roles

Application roles provide a practical way to assign application-specific permissions in your database and to make sure that your applications always use a defined login. Not to be confused with actual roles, application roles are more like users in the database.

Continue reading A short introduction to application roles
Published 2013-04-21
Categorized as Basics, SQL Server concepts, SQL Server security, T-SQL Tagged application roles, login, logon, permissions, security, user
sqlsunday.com
Proudly powered by WordPress.