Connect to SQL Server as a different windows user.

SQLWhisperer General March 19, 2013January 19, 2014 1 Minute

Sometimes, we want to connect to sql server(local or remote) as a different Windows user(not the one you are already logged in).
In that case–> Go to Run and type
RunAs /User:DomainName/UserName SSMS.exe

This is will prompt for password and after you enter the password, it will let you connect to sql server as a different windows user.

Published by SQLWhisperer

Hello Everyone. My intention of having this site is to have one repository location for my SQL Server Learning's. Most of the information here is already available on Web but I want to have it in one global location, so I can reference whenever I need . I would be more than happy, if you find anything on this blog useful. Also, Please use your own caution when running any code on your systems.Thank you for visiting. View all posts by SQLWhisperer

Published March 19, 2013January 19, 2014

%d bloggers like this:

	Powershell script to… on SQL Query to Find SQL Cluster…
	best website solutio… on PowerShell – Script to g…
	Report file sizes in… on Report Time in proper for…
	Display time HH:MM:S… on Report file sizes in proper…

Share this:

Like this:

Related

Published by SQLWhisperer