tisdag 8 september 2009

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...

Inga kommentarer:

Skicka en kommentar