|3.2 and Later||How-to||
How to check which Auth scheme is used by Scalearc on some Query from within SSMS
Follow steps below to achieve the objective:
a. Open SSMS --> Add the Scalearc VIP address in "Connect" window.
b. Once a connection is established with Salearc then following screen will appear in SSMS.
c. Now open a Query window and give Query like:
SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid ;
It is verified that the Query coming to Scalearc is authenticated as Kerberos from the output of Result window above.