How to check authentication scheme in SQL 2005/SQL 2008?


You can use below query to check authentication scheme whether it is Kerberos or NTLM.

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

Thanks for the comment, will get back to you soon... Jugal Shah