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

Written by

Jugal Shah

in

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

Comments

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

More posts