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

.net apps using SQL connections that aren’t closed properly

I already blogged about this partially here, and of course having debug disabled comes into play as well. Anyway, we figured out a problem here at work that is well documented here. It’s a good read and was really helpful for us to figure out how to recode the app.