Setting up kerberos for SQL Server 2008 R2 not taking effect

Posted by dotnetdev on Server Fault See other posts from Server Fault or by dotnetdev
Published on 2011-11-17T22:56:01Z Indexed on 2011/11/18 1:53 UTC
Read the original article Hit count: 551

Filed under:
|

I am trying to configure Kerberos for my SQL Server (the database engine domain account). I have executed the following command:

SETSPN -A MSSQLSvc/MyDBServer:1433 MyDomain\SQLServerService

Replacing MyDBServer with the FQDN of the server and replacing MyDomain\SQLServerService with the name of my account.

I then ran the query:

SELECT s.session_id , c.connect_time , s.login_time , s.login_name , c.protocol_type , c.auth_scheme , s.HOST_NAME , s.program_name FROM sys.dm_exec_sessions s JOIN sys.dm_exec_connections c ON s.session_id = c.session_id

This returns NTLM. So it's not Kerberos. What am I mising? The delegation tab is available for the account, so the spn bit worked perfectly fine. Is it not required to set some settings in the delegation tab? I've seen this in the case of setting kerberos for Sharepoint 2010 (which I intend to setup).

Thanks

© Server Fault or respective owner

Related posts about sql-server

Related posts about kerberos