开发者

Connecting to SQL Server 2005 on another domain through VPN connection

开发者 https://www.devze.com 2023-01-01 23:47 出处:网络
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?

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..

0

精彩评论

暂无评论...
验证码 换一张
取 消