Replication over VPN

I am new to both replication & VPN setup.
I've been asked to replicate a DB from WinXP SP2 to Server 2003 over a VPN.
Both machines are running SQL 2000 3a.
The VPN appears setup correctly (almost) - I can ping both ends and name
resolution is OK. However, I can't browse the server shares from the PC or
vice versa.
In Ent Man I can connect to the servers on both machines but browsing the DB
tables is very slow and most often results in general network failure errors.
Questions:
1. Will SQL Server operate over a VPN or does port 1433 have to be open at
the firewall?
2. I have tried setting up Snapshot Replication with Push Subscription
without success. What is the simplest way to achieve the goal of copying the
DB from XP to the server on a regular basis?
Thank you.
1 )Replication does work over a VPN, but as you have found out it does take
longer than if you were replicating locally over a LAN/WAN.
2) set LoginTimeout and QueryTimeout to large values. The fact that you
can't browse server shares to me indicates that the RPC ports aren't open.
In this case you will probably have to use FTP will a pull subscription.
"MikeH" <MikeH@.community.nospam> wrote in message
news:79A546ED-8473-4BED-9508-501EF601AE86@.microsoft.com...
>I am new to both replication & VPN setup.
> I've been asked to replicate a DB from WinXP SP2 to Server 2003 over a
> VPN.
> Both machines are running SQL 2000 3a.
> The VPN appears setup correctly (almost) - I can ping both ends and name
> resolution is OK. However, I can't browse the server shares from the PC or
> vice versa.
> In Ent Man I can connect to the servers on both machines but browsing the
> DB
> tables is very slow and most often results in general network failure
> errors.
> Questions:
> 1. Will SQL Server operate over a VPN or does port 1433 have to be open at
> the firewall?
> 2. I have tried setting up Snapshot Replication with Push Subscription
> without success. What is the simplest way to achieve the goal of copying
> the
> DB from XP to the server on a regular basis?
> Thank you.
>
|||Hilary
Thank you for the response. The recuperative power of a server reboot is
truly amazing. I can now browse shares and replicate servers.
"Hilary Cotter" wrote:

> 1 )Replication does work over a VPN, but as you have found out it does take
> longer than if you were replicating locally over a LAN/WAN.
> 2) set LoginTimeout and QueryTimeout to large values. The fact that you
> can't browse server shares to me indicates that the RPC ports aren't open.
> In this case you will probably have to use FTP will a pull subscription.
> "MikeH" <MikeH@.community.nospam> wrote in message
> news:79A546ED-8473-4BED-9508-501EF601AE86@.microsoft.com...
>
>