Saturday 21 April 2007

Determine SQL Authentication Method (2005)

Query to determine authentication method in use between client & server -
SELECT AUTH_SCHEME
FROM   SYS.DM_EXEC_CONNECTIONS
WHERE  SESSION_ID = @@SPID;

Possible return values are -




Login TypeAuthentication Scheme
SQLSQL
Windows
NTLM
KERBEROS
DIGEST
BASIC
NEGOTIATE

No comments: