Monday, April 16, 2012

Query to check whether the authentication scheme of the SQL Server is set to kerberos or NTLM

-- Query to check whether the authentication scheme of the SQL Server is set to Kerberos or NTLM

select auth_scheme from sys.dm_exec_connections where session_id=@@spid

No comments:

Post a Comment