Get current authentication provider

Posted on Wednesday, July 1st, 2009 at 1:53 am in

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

This command should return NTLM or Kerberos

Add your comment

Leave a Reply

Leave A Comment

Top