Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: merge replication problem

    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 ?

    Thanks folks

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts