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
Best Answer
I have found I need to register SPNs for different syntax for describing sql server. For some reason sql uses different syntaxes along the way to authenticating. Register each of these formats.