Last post Oct 26, 2017 02:15 AM by Deepak Panchal
Oct 25, 2017 07:11 PM|kanmai|LINK
How to Connect / to create Connection String to Remote SQL Server which is in Different Domain?
Oct 26, 2017 02:15 AM|Deepak Panchal|LINK
you can try to use "RunAs" command.
set /p domain="Enter Domain: " %=%
set /p username="Enter Username: " %=%
runas /netonly /user:%domain%\%username% "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
Connect to a SQL Server on a different domain
Connect to SQL Servers in another domain using Windows Authentication
other method to connect to SQL server on other domain.
(1) Open Credential Manager
(2) Click "Add A Windows Credential"
(3) Populate the "internet or network address" field with the name and port number of the SQL instance you wish to store credentials for.
Example: UniServer:1433 (1433 is the default port, you may need a different port, especially if you are connecting to a named instance)
(4) Populate the "User Name" (don't forget to include the domain e.g. MYDOMAIN\MYUSER)
(5) Populate the "Password"
(6) Click OK
Connect SSMS to a server in a different domain