Authentication Mode

To find out if you are connected to SQL Server using NTLM authentication or Kerberos.

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

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