August 1, 2005 at 12:09 pm
I'm trying to setup merge replication between two server (serverA and serverB). serverA houses the publisher DB (pubs) and Distribution DB (distribution), server B has the subscriber DB (subs). I tried first to setup a pull subscription, but the snapshot is never created in the subs db, even though the snapshot agent says everything was successful. The merge agent also never changes from the status 'Never Started'.
So I tried a push subscription. This gets me a little further, it creates the snapshot in the subs DB, but then the merge agent fails with the following error.
The subscription to publication 'pubs_customer_test' is invalid.
(Source: Merge Replication Provider (Agent); Error number: -2147201019)
---------------------------------------------------------------------------------------------------------------
The remote server is not defined as a subscription server.
(Source: BBLABCW03 (Data source); Error number: 14010)
---------------------------------------------------------------------------------------------------------------
Please help. Thanks.
August 2, 2005 at 4:12 am
Is your subscriber registered in EM or is your publication enabled for anonymous replication.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
August 2, 2005 at 6:58 am
Hilary, I figured out the problem, my servername was messed up on the subscriber. Changed that and everything works fine now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply