Have you ever wanted to check which method you are using to authenticate to a SQL backend? Just run the following SQL to return the current authentication scheme your user context is using.
SELECT session_id, auth_scheme FROM sys.dm_exec_connections WHERE session_id=@@spid
You can easily modify the above to give you the authentication...
Read more
