Get current authentication provider
SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id=@@spid
This command should return NTLM or Kerberos
Leave a Reply
SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id=@@spid
This command should return NTLM or Kerberos