Connecting to SQL Server 2005 on another domain through VPN connection

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 just sqlserver
• 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..