On a windows laptop, when I open Sql Server Management Studio (SSMS) (or any other application like Visual Studio or mstsc [RDP]) as run as a different user , a pop-up appears asking for credentials of the new user.
In my case, I'm trying to open the application using a domain account that is not readily accessible (this is important) to the laptop -- where I'm performing this run as a different user operation.
Goal is to connect to a database in Amazon Web Services (AWS), using SSMS installed on my local laptop. The network connection to AWS is managed through Putty tunnel (intermediary server that performs LocalForward to the destination AWS server).
Question is -- how do I bypass the initial pop-up screen that asks for my credentials?
The problem is, even if I provide the correct credentials in this pop-up, it says incorrect credentials. As it could not reach the AWS Active Directory (AD) to validate my credentials correctly.
The actual connection to the database server on AWS is attempted through localhost,1234, which is rerouted to the destination AWS server through the intermediary server. This set up is achieved within Putty tunnel configuration successfully for RDP connections.
Once I open the application, I could connect to the database server using localhost,1234 as localhost at port 1234 is rerouted to AWS intermediary server that redirects all connections to the database server let's say DB-Server:1433. Using Windows account authentication I can provide my credentials for AWS domain (not local laptop domain in our office)
Since the AWS AD is not available when the first open the application (as run as a different user), it cannot authenticate the credentials I provide and it fails to even open the application "as a different user".
How do I solve this problem?
Thanks, Toc
