Verify Kerberos in a SQL Server installation

Use the SQL Server Management Studio, connect to the server (note you must NOT do this locally on the server). Execute this T-SQL:


SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid;


It will return either "NTLM" or "KERBEROS".

More on Kerberos will follow...