How to check authentication scheme in SQL 2005/SQL 2008?
Posted by Jugal Shah on April 12, 2010
You can use below query to check authentication scheme whether it is Kerberos or NTLM.
select auth_scheme from sys.dm_exec_connections where session_id=@@spid
18.520469
73.856621
Like this:
Be the first to like this post.
This entry was posted on April 12, 2010 at 2:55 pm and is filed under SQL Server.
Tagged: Authentication Scheme. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
