Joseph Michael Pesch
VP Programming

Determine Authentication Scheme on SQL Server

by 22. March 2013 14:12

Below is a TSQL statement that will return the current authentication scheme running on your SQL server instance.

SELECT net_transport, auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@SPID;

Tags:

SQL Server

Comments are closed