Tuesday, October 5, 2010

How to determin if you are logged in via Kerberos or NTLM on SQL Server

Simply run the following query.

SELECT
    c.session_id
   ,s.login_name
   ,c.auth_scheme
   ,c.net_transport
   ,s.host_name
   ,s.login_time
   
FROM sys.dm_exec_connections c
INNER JOIN sys.dm_exec_sessions s on s.session_id = c.session_id  

0 comments:

Post a Comment