Log on to SQL Server as a different Windows Account

Question

Post reply

Log on to SQL Server as a different Windows Account

Welsh Corgi

SSC Guru

Points: 116520
More actions
November 11, 2016 at 7:25 am

#315545

I need to Log on to SQL Server as a different Windows Account.
I tried the following but it did not work.
“Right Click” with Shift key pressed and then use “Run as Different user” to use the admin account.
Please let me know what I have to do?
Thank you.
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/
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Run Management Studio as the admin user, then connect to SQL as normal.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 2

Welsh Corgi (11/11/2016)
I need to Log on to SQL Server as a different Windows Account.
I tried the following but it did not work.
“Right Click” with Shift key pressed and then use “Run as Different user” to use the admin account.

This works for me. What happens when you do it?

DamianC SSCrazy Eights Points: 8023 More actions · Answer 3

This works for me.

Is it definitely an admin account?

What error do you see?

- Damian

HanShi SSC-Dedicated Points: 33507 More actions · Answer 4

Welsh Corgi (11/11/2016)
I need to Log on to SQL Server as a different Windows Account.
I tried the following but it did not work.
“Right Click” with Shift key pressed and then use “Run as Different user” to use the admin account.
Please let me know what I have to do?
Thank you.

Although you did not mention it, I assume you are starting SSMS with the [shift] + right-click method.

What is filled as "user name" in the greyed out area of the connection window after SSMS is started with the "run as different user" option? Does the account with that name has permissions to connect to the SQL instance?

Look in the SQL Error log (using another account that has permissions) to see the details/additional messages related to the "login failed" error. This should give you a clue about why you can't login.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

mister.magoo SSC-Forever Points: 47174 More actions · Answer 5

Try reading this[/url] for a couple of ways..

It sounds like you are just running SSMS in administrator mode, not as a different user.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Tac11 SSCertifiable Points: 6980 More actions · Answer 6

if you do RDP to the server and right click on SSMS logo it gives your an option as 'run as different user" but it doesn't work on client

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

Tac11 (11/18/2016)
if you do RDP to the server and right click on SSMS logo it gives your an option as 'run as different user" but it doesn't work on client

Hmm... I have ran as an admin from the Client before with no problems.

I'm closing this out for it is no longer an issue.

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/