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)
 Replication Problem using VPN

Author  Topic 

gmetaj
Starting Member

33 Posts

Posted - 2004-05-28 : 12:53:40
I am trying to configure snapshot replications using VPN to another server over the internet.

The problem is that it is giving me an error saying that it is not being able to establish a connection the subscriber. The VPN connectin is set and I am able to ping the Subscriber server (IP: 192.168.0.5) I am using PUSHING the snapshot from the PUBLISHER which is the same as the DISTRIBUTOR to the SUBSCRIBER (Located on the internet, but due to the VPN then it should act as a SERVER on the network according to BOL)

My questions are:

1. Do i need to register the subscriber to be able to do replications?
2. Is there a way to perform replication without registering the server even though it's through vpn. The reason to this is that on the same subscriber server there are other databases who belong to other customers (different from the customer that is connecting to perform publications)
3. The subscriber server is configured to use mixed mode authentication. Can I use any account that has administrator/rights or owns the database to be able to perform the replication?

Thank you for all your feedback and time!
   

- Advertisement -