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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.