January 26, 2017 at 9:13 am
Hi,
In SSMS you can run as a different user.
I got the pop up one time but I can't get it to come up again.
I'm trying to do it from Windows 10.
Any help would be greatly appreciated.
When I try clicking on ssms.exe nothing happens by following the instructions listed below.
I want to do it in SSMS as opposed to clicking on a file.
http://www.sqlrelease.com/open-sql-server-management-studio-as-different-windows-user
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 26, 2017 at 9:19 am
The only way I know of to run SSMS as a different user is:
Start>All Programs
Find the version of SSMS you want
Shift&Right Click on the SSMS option
That will give you a menu that includes "Run as a different user"
added: You can connect to a server via a different login, when you click on Connect and chose one of the options, it gives you a pop-up where you can change how you connect to that server...but that is a 'one time' thing and you would have to do that with each connection.
-SQLBill
January 26, 2017 at 11:20 am
if you're just trying to test permissions to a query or update or something through management studio, you could possibly use the EXECUTE AS command to impersonate a different login or user in your query window:
https://msdn.microsoft.com/en-us/library/ms181362.aspx
January 27, 2017 at 1:54 am
Hi,
if you are trying to start SSMS with credentials from a foreign domain, try this:
runas /netonly /user:DOMAIN\USERNAME "C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe"
This would start SSMS 2012
Andreas
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply