ScaleArc Support Center

Welcome back, guest

Register or login below.

Downloads

Feedback

How to check Auth method used by Scalearc from SSMS

 

 

 

Release Classification Level DB Platform Category
3.2 and Later How-to
SKILLED

MSSQL

Administration

 

QUESTION

 How to check which Auth scheme is used by Scalearc on some Query from within SSMS

ANSWER

 

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 1;

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.

 

 

 


 

If you are experiencing issues with ScaleArc or with any of it's features, please contact ScaleArc Support.

We are available 24x7 by phone at 855 800 7225 or +1 408 412 7315.

For general support inquiries, you can also e-mail us at support@scalearc.com.

Copyright ©2014 ScaleArc, Inc. All rights reserved. Contact Support |  Contact ScaleArc |  Feedback

2901 Tasman Drive Santa Clara, CA 95054 | Email:  support@scalearc.com

 

 

 

 

 

Permalink: https://support.scalearc.com/kb/articles/4096