SSMS - Authenticate with alternate Domain credentials

Question

SSMS - Authenticate with alternate Domain credentials

Warren Peace

SSCertifiable

Points: 5881
More actions
October 23, 2007 at 9:55 am

#376002

In the SSMS, there are two ways to authenticate. The first is with current domain log in (passthrough authentication) and the other is SQL authentication. Is there a way to use a different Domain account to authenticate to the database engine from SSMS instead of passthrough? Basically I want to log in as another Domain account to test security.
If there is how can I do this? What do I need to change?
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

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

Source-NH SSCarpal Tunnel Points: 4165 More actions · Answer 1

You will not be able to directly log in using an alternate account unless you have that account's password and can log in to the network.

However, there is a alternative. If you create a login that maps to that widows user in SQL server, you will then be able to use the "Execute as" to change your identity once you are logged in. See books on-line for more info about the Execute As.

HTH

fhanlon SSChampion Points: 13131 More actions · Answer 2

If your SQL Server is on domain A and you authenticate to domain B on your workstation, you should be able to connect to the SQL Server if there is a trust relationship from A to B. You can then give your id (B\login) the appropriate access on A. You may need to contact your Network\Infrastucture group to set up the trust.

Francis

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

Start SQL Server Management Studio with an alternate set of credentials. There are two ways of doing this:

1) Hold down the shift key and right-click on the icon. Choose the Run As option from the pop-up menu. When prompted for credentials, specify the alternate set.

2) Use the runas command to execute sqlwb (the executable for SQL Server Management Studio), such as from Start | Run. For instance:

runas /user:mydomain\myuser sqlwb

As has been indicated, if the alternate set of credentials is in a different domain, check with your directory administrators to see if a trust is in place.

K. Brian Kelley
@kbriankelley

hal mayne Valued Member Points: 71 More actions · Answer 4

That will only work if it can authenticate your remote domain login locally.

Warren Peace SSCertifiable Points: 5881 More actions · Answer 5

Thanks everyone for the replies. I simply wrote a vbscript that prompted for credentials (not safe but for testing it works) to connect via SQL Native Client to my servers to run a basic query. If it failed it failed. If it worked it worked. It's much faster than waiting for SSMS to start to test credentials.

Thanks