Browse by Tags

Check Authentication Scheme (Kerberos) on SQL Server 2005

I had to redo SPNs today because we swapped out service accounts on some of our non-production SQL Servers. I wanted to verify that connections in bound were being made with Kerberos. If you've ever dealt with this, if the SPNs are wrong you usually get an SSPI error, but just to be safe, I wanted...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 08-07-2008
Setting Static Ports when dealing with Named Instances and Kerberos

I ran across this a week or so ago. There were a couple of SQL Servers running named instances that we wanted to setup Kerberos authentication against (in the event we would use Kerberos delegation). Here is how the ports were set according to SQL Server Configuration Manager: The problem here is that...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 05-17-2008
Configuring SPN for SQL Server Browser service

Going through the Microsoft KnowledgeBase updates, I saw this one: An SPN for the SQL Server Browser service is required when you establish a connection to a named instance of SQL Server 2005 Analysis Services or of SQL Server 2005 The situation occurs when the client is connecting to a Named Instance...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 04-04-2008

Page 1 of 1 (3 items)

SQLServerCentral.com