May 22, 2015

Recently, I had to login to a SQL Server to get some data but the pain was I had to login to remote desktop using a different windows username and then opening Sql Server Management Studio and then opening connection to the Sql Server in a different server. I was thinking this is just crazy and I would simply just want to connect to the sql server using my local Sql Server Management Studio.

Well, I could not find any option in Sql Server Management Studio and the default windows username is set as the logged in user in the device. I tried right clicking on Sql Server Management Studio and it had another option for running it as an administrator - no option for running it as a different user. What I didn't know and only found out a few days later while doing a different stuff is that windows 7 has another option for starting software. We could use Shift + Right Click which gives a different option for running software and in this case to run it as a different user. I simply chose the option "run as a different user" and I could type in my other windows username and password and then run Sql Server Management Studio. Then I could easily connect to the required Sql Server. This just saved my some frustration on connecting to the Sql Server.

0 comments:

Reference: Shahed Kazi at AspNetify.com