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 2000 Forums  Import/Export (DTS) and Replication (2000)  Merge Replication Failure

Author  Topic  rgeyer Starting Member 1 Post Posted - 2002-10-09 : 17:10:54 I setup merge replication between two SQL Server 2000 servers that communicate via a VPN over the internet. The VPN is stable with little to no packet loss and 200-400 ms latency. I have configured a push subscription from the publisher db. The initial snapshot is replicated flawlessy, however the subsequent merge replications always fail after 10 retries with a network error: The merge process encountered an unexpected network error. The connection to Subscriber 'EXCELSQL1' is no longer available. Why would the initial snapshot replicate flawlessly and then all subsequent replication attempts fail? I work on the same VPN connection and it is very stable. Any thoughts?