Feeds:
Posts
Comments

Archive for September, 2018

Interesting one today:

Occasionally we need to connect to Sql Server over Windows Authentication using different Windows user. This is a good step to manually check a few things about the validity or privilege level for that other Windows Account (there are other ways too).

One of the quickest way is to Connect to Sql Server over Windows Authentication using the other Windows account.

By default, when you open SSMS (Sql Server Management Studio) under Windows Authentication, it pre-populates our current windows account. There are a couple of options to workaround that.

Solution 1: Use runas

From a windows command prompt or a Run window, run the following runas command with the other Windows user

runas /user:domain\user Ssms.exe

New SSMS window opens up with the above mentioned Windows User account pre-populated.

Solution 2: Use RunAs from windows menu

Same steps as above, but we use windows user interface to perform the same steps.

Right click on SSMS and go to pop-up menu:

SSMS_DifferentUser_1

On “Microsoft Sql Server Management Studio 17“, press Shift + Right click

SSMS_DifferentUser_2

On the new SSMS, you could specify the new Windows Account (or Domain Account) to use for login.

Hope this helps,
_Sqltimes

 

Advertisements

Read Full Post »