Unable to connect to a remote SQL Server Instance over a VPN

Posted by Jack Njiri on Server Fault See other posts from Server Fault or by Jack Njiri
Published on 2010-02-09T11:27:52Z Indexed on 2010/04/10 11:33 UTC
Read the original article Hit count: 318

Filed under:
|

I'm running SQL Server 2005 on two different servers running Win XP. The two servers are in different physical locations and are connected via a dedecated point to point data link in a virtual private network(VPN). Im only able to connect to the remote instance of SQL Server by specifying the IP address on the server name property. If I provide the actual server name say 'ServerA', then I get an error message. Everything works fine except configuring replication at the subscriber level, which requires the actual name of the instance, not an IP address or alias. I have already configured both instances on allow remote connections and im running the SQL Server Browser.

How do I connect to the remote instance by providing the instance name?

Alternatively how I configure subscription to a remote publisher without supplying the remote instance name?

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about vpn