Hello,
I have SQL Server 2005 dev installed on my machine.
Using SQL Server Management Studio: how can I connect to a SQL Server on another domain?
Please note that the computer has to be VPN'ed into the domain I am connecting to.
Thanks, Voodoo
views:
172answers:
3
+1
A:
Once you're vpn'd in it should be just like local network. Put the fully qualified server name in the connection dialog in SQL Management Studio.
Sam
2010-06-04 02:05:06
Thanks for the reply. At what point do I put the server name in? at Object Explorere or in the Registered servers? Could you give me step by step explanation - pretend you are talking to a sql-server noob.
VoodooChild
2010-06-04 05:07:20
this is not true if you are using windows authentication, it will usually try to send your windows login details, not the vpn login details.
Nathan Reed
2010-06-04 05:11:43
A:
You should be able to do as normal once vpn'd in, but there are a few catches:
- You may have to use the FQDN. ie
sqlserver.network.local, not justsqlserver - windows authentication may or may not work, so probably just log in using a sql account, if you have one.
Nathan Reed
2010-06-04 05:15:16
A:
Turned out the username and password that was provided was removed from their server for unknown reason.... Thanks for the help, appreciated it very much..
VoodooChild
2010-06-07 21:29:15