Access to a SQL Server in some other Domain from SQL Server Management Studio

Senario in brief: My normal working domain is DomainA. But i have to connect to a sql server in DomainB. Administrators have given me remote desktop connection to the server which has sql server in DomainB but not to direct access from my SQL Server management studio.

Following is the solution.

runas /netonly /user:DomainB\sqladmin “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”

paste this infront of your command prompt and give the password for sqladmin user in SqlServer.
find the correct “Ssms.exe” path in your PC as “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe” is in my PC.


Author: Indika Abayarathne

MSc in IT [University of Colombo] Solutions Architect | Consultant Technologies: Power Platform | Dynamics CE | Azure

Leave a Reply

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

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

Facebook photo

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

Connecting to %s

%d bloggers like this: