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=@@spidYou can easily modify the above to give you the authentication schemes for all connections by dropping the where clause.
Browse latest info tech news and developments
Our blog publishes bite-sized IT focused articles that offer an easy-to-read insight into ways you can improve your business, communication and operation.
Showcasing developments in the IT industry, practical advice, and time and money saving tips, it’s worth subscribing to stay up to date with the news that matters.