Posts Tagged ‘sql’

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

March 17, 2011

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

Advertisements

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

October 15, 2010

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.