Replication Merge...subscribing

Replication Merge...subscribing

Post by Joe Tena » Wed, 21 Aug 2002 01:19:18


I have a remote SQL2000 server and I have a publication published on it. I
need it to Merge replicate with a local SQL2000 server.

I have created the publication and enabled the subcribers fro it but when I
try subscribe from the local Server I can't find any publication to
subscribe too.

I've tried to push the subscribtion but that seems to have problems
connecting to the local Server.

I can use entrprise manager to view and manage the remote server but ...

How can I pull subsciption from a remote server? Is there something I'm
missing out?




1. Error when subscribing to Merge replication


We have setup a publisher and a distributor in SQL 2000 running SP3.
Alongwith this we have setup a merge replication agent and its running
successfully inside the same network. I allow anonymous subscriptions and
the merge publication works successfully for anonymous pull subscriptions

Now i am trying to setup the same scenario to setup replication over the
Internet using FTP. I have created a FTP site and given certain accounts
credentials to login to the same. I have checked the same over a browser and
the ftp protocol is working perfectly.

In my publisher i have changed the path of the snapshot folder to the ftp
folder (which is in the same network). I refer to the same in snapshot
location screen as \\Systems\SQL FTP\. It is a shared for which sufficient
rights are there.

The snapshot agent generates the snapshot in this folder without any

Now when i create a pull subscription, and say scynchronize using FTP, it
fails and after checking the job history, these are the messages that were
there -

Source:  Merge Replication Provider
Number:  -2147201001
Message: The schema script '' could not be propagated to the subscriber.

Source:  PARAM
Number:  0
Message: The process could not connect to FTP site '' using
port 21.

Number:  12003
Message: 550 The filename, directory name, or volume
label syntax is incorrect.

The schema script '' could not be propagated to the subscriber.  The step

And by the way, if i try to push the subscription via FTP it works without
any problem.

Can someone please advice what is to be done ? Thanks in advance!


2. Creating lobindexes

3. How to subscribe a Merge Replication using MSDE

4. SQL: conditionally return string constants for certain fields

5. Unable to subscribe merge replication

6. SQL Server Upload

7. Message - No data needed to be merged - using merge replication

8. Help with NOT EQUAL in SQL statement

9. Merge Replication : Merge Agent fails with Garbled sp name errors

10. merge replication using Active X merge control

11. merge replication doesn't merge records

12. Merge Replication with ftp fails after adding A New Merge Article

13. Merge Replication, on-demand PULL replication