Have you ever required to open SQL Server Management Studio Application (SSMS instance) as different windows user from your local machine? Sometimes we require to “Run SSMS instance as different Windows user” another machine which is not available physically to us. In such type of scenarios we can open our local SSMS instance as different windows user at our local machine. In this article we are going to learn how we can open SSMS instance as different windows user. If you are still not required this till now, may be sometime in future you will be required to do the same.
Now to accomplish this task i.e. to open SSMS as a different windows user, we have below approaches;
- Using Run as different user option in windows explorer
- Using runas command in command prompt
- Using runas command with “.bat” file
We will cover all the above techniques below.