Windows Authentication to a Different Domain
SQL Server Management Studio 2008
Follow the instructions below to use SSMS 2008 to authenticate to a different domain using Windows Authentication. This procedure should only be used when using Windows Authentication and is not required for SQL Authentication.
Summary: Use the "runas" command from the command prompt with the /netonly switch. If the /netonly switch is not included, a "no logon servers" message will appear. It will appear like the current domain account is being used; however, the Domain account credentials will be passed to the SQL Server instance.
1. Launch
a command prompt window.
2. Enter
the following command string, substituting the “myDomain\user” with your
credentials. Note the path for SSMS 2005 will be different. Domains:
CITdev (DEV); CITtest (TEST)
%windir%\system32\runas.exe / user:myDomainname\login
/netonly "C:\Program Files\Microsoft SQL
Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"Examples using my credentials to authenticate to the DEV domain:
%windir%\system32\runas.exe / user:cit\ramponn /netonly "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
3. You
will be prompted for your Domain password.
