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
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.
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.
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..
精彩评论