Showing posts with label Kerberos. Show all posts
Showing posts with label Kerberos. Show all posts

Tuesday, June 14, 2011

Kerberos Authentication on SQL

The following SQL query shows the authentication scheme used for the current session:
select auth_scheme from sys.dm_exec_connections where session_id=@@spid

To show details on all sessions, use the following query:
select * from sys.dm_exec_connections