HELP!!!! Merge Replication

  • I am running up against a deadline here and I can't seem to get through this problem. I am trying to set up merge replication and I have set up the publication and created the initial snapshot, but when I try to push the subscription, I get the follwoing error:

    The subscription to publication 'USERACCESS' is invalid.

    (Source: Merge Replication Provider (Agent); Error number: -2147201019)

    ---------------------------------------------------------------------------------------------------------------

    The remote server is not defined as a subscription server.

    (Source: FMRJH-SV556-134 (Data source); Error number: 14010)

    ---------------------------------------------------------------------------------------------------------------

    Has anyone seen this before...

    If ain't broke, don't fix it


    If ain't broke, don't fix it

  • Does your SQLServerAgent account have access on the remote server? You might wanna checkout this Technet article Q321822.

    [font="Verdana"]Markus Bohse[/font]

  • I running the mssqlserver and sqlserver agent under the domain admin account. Any other suggestions. I don't know the address to the technet site....can you post that web address?//

    If ain't broke, don't fix it


    If ain't broke, don't fix it

  • http://www.microsoft.com/technet

    [font="Verdana"]Markus Bohse[/font]

  • Also, wrt your second error, Is your remote server defined as a Subscriber?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply