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: 347
sql-server-2005
|vpn
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