Get current authentication provider
SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id=@@spid
This command should return NTLM or Kerberos
Tags: Authentication Provider, MSSQL, T-SQL
July 1, 2009 1:53 am 
Subscribe
-
Search
-
Pages
-
colleagues and friends
Fun
my sites
Categories
-
Search
Tagcloud
Authentication Provider Automatic Logon Bash Blog Certification FIM 2010 Games Groove Icinga iSCSI Live Mesh MCITP MCTS MOSS 2010 MSSQL multiple computers Nabaztag Nagios OneNote Password SharePoint Workspace SSH Sync T-SQL Theme User Profile Service Application Windows Storage Server 2008 WSS2008Archives
Meta
Calendar
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| Aug » | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||