I found myself looking for this query for the second time now and finally decided to post it on my blog This query enables you to find out if your connections towards your SQL server are using Kerberos instead of NTLM. This may help in your troubleshooting...