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