I need to merge data from 2 tables on different servers running on SQL server 2000. I a trying to use the merge replication function of SQL 2000 but there is One major problem. One of my server is on the internet and the other is inside our network so I dont want any data being pushed from our server on the internet to our server inside our network.
The publisher is our internal server (distributor is also on this server) and the subscriber is the internet server. I am also using the push subscription option for the subscriber. Right now our firewall blocks acces from our internet server (subscriber) to our inside server(publisher) and i get an error message from the merge agent saying the process could not connect to subscriber.
Is there any way to make it work using the merge agent ?