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 Type	Authentication Scheme
SQL	SQL
Windows
NTLM KERBEROS DIGEST BASIC NEGOTIATE