Maury Markowitz
Maury Markowitz

Reputation: 9303

SQL Server MS, change user for Windows Authentication

I'm using a VPN to access a remote SQL Server. Normally I would run SSMS on my machine and use SQL Server Login for access. However, this server is set up to allow in only a particular user using Windows Authentication. I can access the DB by RDPing to that server and using SSMS on that machine, but is there any other way to do it from SSMS on my local machine?

Upvotes: 0

Views: 3146

Answers (1)

Greg
Greg

Reputation: 4055

Simplest way:

  1. open up a command line window - cmd.exe
  2. do the following: runas /user:<domain>\<alias> cmd.exe
  3. enter your password when prompted
  4. do the following: ssms.exe

it should now launch SSMS.exe under the account in #2 above.

Upvotes: 2

Related Questions