The word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators.
What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works.
We will look at
- What is the purpose of Kerberos in relation to SQL Server?
- When do we need to use it? Do we need to worry about it at all?
- How do we configure it? What tools can we use?
- Who can configure it? Is it the DBA job to manage and configure Kerberos?
- Why does it cause so many issues?
Because on the face of it setting up Kerberos for a SQL Server is actually straightforward but it is very easy to get wrong and then sometimes very difficult to see what is wrong preview here
https://www.youtube.com/watch?v=uO9NqxizT_8