SQL Server Management Studio & Windows Authentication across Domains

Posted on by
Getting access to a SQL Server in a different domain using SSMS.
When using SSMS to connect to a SQL Server in a different domain there is no way to type in an alternate DomainUsername through the UI. To connect to a SQL Server in a different domain using SSMS we need to do the following:
  • runas /netonly /user:[DOMAIN]\[USERNAME] “C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”
  • You will then be promted for the users password which you should provide.
  • When SSMS starts up, type in the server name (or IP address) into the Connect To Server dialog and ensure the Authentication is set to Windows Authentication.
  • You do not need to worry about the Username/Password as this will be overridden. Press OK and you should be connected to the server in the different domain.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out / Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out / Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out / Change )

Google+ photo

You are commenting using your Google+ account. ( Log Out / Change )

Cancel

Connecting to %s