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

Your email address will not be published. Required fields are marked *