SQL query to tell if SQL logins are using Kerberos or NTLM

Not explanation needed here, if you know what you are looking for, this is it.

SELECT 
s.session_id
, c.connect_time
, s.login_time
, s.login_name
, c.protocol_type
, c.auth_scheme
, s.HOST_NAME
, s.program_name
FROM sys.dm_exec_sessions s
JOIN sys.dm_exec_connections c
ON s.session_id = c.session_id

Advertisement

Tags: biztalk, kerberos, ntlm, sql