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.

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


Tags: , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s