replication over vpn - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

replication over vpn

Author

Topic

Jedi Master
Starting Member

3 Posts

Posted - 2008-06-17 : 02:53:13

Hi there. I've got a problem which I can't seem to solve. This is going to be lengthy as I will try to give maximum details so no misunderstanding occurs.

Location A
Windows 2k3 Enterprise with latest updates and 2 NICs
Active Directory, Computer name: PLAUZUN
Domain: PLAUZUNDOM, FQDN: plauzun.plauzundom.plyfoam.local
Running DNS, DHCP, RRAS and SQL Server 2005 with SP1
DNS configured with 2 Forwarders (ISP DNS) and domain: plauzundom.plyfoam.local
RRAS configured with static pool: 192.168.1.81 – 192.168.1.100 (20 addresses)
NIC1 IP 192.168.1.1, Gateway: empty, DNS: 192.168.1.1
NIC2 IP 192.168.11.2, Gateway: 192.168.11.1, DNS 192.168.1.1
Netgear ADSL Router LAN: 192.168.11.1 and with public IP.
Netgear firewall allow SQL(TCP 1433, UDP 1434) and VPN/PPTP(TCP 1723)

Sql Server 2005 contains testdb1 published with merge replication.
All TCP/IP interfaces protocols configured with static port 1433.

Location B
Windows 2k3 Enterprise with latest updates and 2 NICs
Active Directory, Computer name: PLOUIS
Domain: PLOUISDOM, FQDN: plouis.plouisdom.plyfoam.local
Running DNS, DHCP, RRAS and SQL Server 2005 with SP1
DNS configured with 2 Forwarders (ISP DNS) and domain: plouisdom.plyfoam.local
RRAS configured with static pool: 192.168.2.81 – 192.168.2.100 (20 addresses)
NIC1 IP 192.168.2.1, Gateway: empty, DNS: 192.168.2.1
NIC2 IP 192.168.12.2, Gateway: 192.168.12.1, DNS 192.168.2.1
Netgear ADSL Router LAN: 192.168.12.1 and with public IP.
Netgear firewall allow SQL(TCP 1433, UDP 1434) and VPN/PPTP(TCP 1723)

Registered dynamic address at dyndns.org for both locations.

From B, established VPN connection from B to A successfully using admin account in A. Address obtained with IP 192.168.1.82. Ping plauzun and plauzun.plauzundom.plyfoam.loca returns 192.168.1.1.
Using SSMS, connect to local server PLOUIS\PLOUIS
Under replication, New Subscriptions ? Publisher:
In Connect to Server, server name: PLAUZUN\PLAUZUN
returns: Cannot connect to PLAUZUN\PLAUZUN.
Additional information: TCP Provider, Error 0 and MSSQL Server Error: 10060

But if I connect to server PLAUZUN\PLAUZUN, 1433 in the object explorer, it is successful. If I try to use the above servername\instance, tcpport in the Subscription window I get

“SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'PLAUZUN\PLAUZUN'. (Microsoft.SqlServer.Express.Replication.Utilities)”

Any ideas at to what I must do?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-17 : 09:39:48

Did you put Servername\Instance while setting up?

Jedi Master
Starting Member

3 Posts

Posted - 2008-06-17 : 23:22:27

quote:
Originally posted by sodeep

Did you put Servername\Instance while setting up?

Yes I did. For each server.

Jedi Master
Starting Member

3 Posts

Posted - 2008-06-18 : 07:02:41

It's all working correctly now. I had to add an alias as:
Alias name: PLAUZUN\PLAUZUN
TCP/IP Port: 1433
Server: PLAUZUN

at the PLOUIS server to do the job. Thanks for the inputs!

betesh
Starting Member

34 Posts

Posted - 2008-06-19 : 08:23:16

Jedi, how did you get this to work? I have tried the same thing. I made an alias with the alias name as the server name\instance name but I still cannot do the replication over vpn.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-19 : 23:03:53

Did you try to create alias with ip address and port number?

betesh
Starting Member

34 Posts

Posted - 2008-06-22 : 08:21:44

Yes I did but nothing worked until I modified the Lmhosts file with the ip address and server name.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources