Reputation: 9303
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
Reputation: 4055
Simplest way:
runas /user:<domain>\<alias> cmd.exe
ssms.exe
it should now launch SSMS.exe under the account in #2 above.
Upvotes: 2