How to login using a different domain ID in SSMS?

Question

Post reply

How to login using a different domain ID in SSMS?

halifaxdal

SSCoach

Points: 19741
More actions
January 15, 2014 at 10:16 am

#282291

Hello,
I have a project that will use a dedicated domain id, I do not have the password although I can use it to connect to the subject server/db.
I wonder if it is possible to connect to it in SSMS using the dedicated id?
The id is db_datareader
My own id doesn't have access to the server.
Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

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

halifaxdal (1/15/2014)
...I do not have the password although I can use it to connect to the subject server/db...

Can you elaborate on how you currently use this ID (account) to connect without having the password?

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

Ville-Pekka Vahteala SSCrazy Points: 2458 More actions · Answer 2

I am confused what is what.

Could you rewrite question so that you use terms like database login and domain username?

halifaxdal SSCoach Points: 19741 More actions · Answer 3

I am working on a Dundas Dashboard project, DD allows user to connect to a database using a different domain id as long as the id's password is pre-inputted into the system.

I do not have password for the id although I can use it, but I can only use it within the DD platform.

What I am asking is if there is a way to connect to the db using that id via SSMS?

I know I can "run as " the SSMS but it will ask me for password so it is not workable.

Maybe it is not possible? I really want to hear your input.

Thanks.

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

Without knowing the password it is not possible. Your only options are to ask your Windows admins for the password or try to extract the password from DD.

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

halifaxdal (1/15/2014)
I am working on a Dundas Dashboard project, DD allows user to connect to a database using a different domain id as long as the id's password is pre-inputted into the system.
I do not have password for the id although I can use it, but I can only use it within the DD platform.
What I am asking is if there is a way to connect to the db using that id via SSMS?
I know I can "run as " the SSMS but it will ask me for password so it is not workable.
Maybe it is not possible? I really want to hear your input.
Thanks.

It wouldn't be really secure if you could run applications under another account without knowing the password.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Lowell SSC Guru Points: 323518 More actions · Answer 6

edit: since you don't have access, you couldn't use execute as, sorry.

this solution might depend on whether your application maintains a dedicated connection or just connects and disconnects as needed for data:

can you connect as sa/superuser, and then execute the command EXECUTE AS USER='MyDomain\OtherUser'

then you'd be testing using their credentials right?

disconnecting or issuing the REVERT command would put you back into your superman suit.

I know i test scripts in SSMS like that all the time.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

halifaxdal SSCoach Points: 19741 More actions · Answer 7

Thanks for all replies, I think I should forget it