Kerberos errors in network captures

Here is a link to a great article on how to troubleshoot Kerberos errors using network captures. Not only does this blog post guide you through the process of using Network Monitor or Wireshark to capture and analyze Kerberos related packets, but it also contains a great discussion of the various Kerberos error codes, most common causes, and how to resolve them.

Kerberos errors in network captures by Joji Oshima.

(via Ask the Directory Services Team)

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