blogging about…… Microsoft, Cloud Computing
In: SQL Server| Security
10 Apr 2009SELECT
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
A query to see if a connection is made with Kerberos or NTLM.
login_name together with host_name and program_name will identify the login.
auth_scheme will reflect what security protocol was used