Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Location
    Belgium
    Posts
    43

    Unanswered: MsSql7 merge replication error

    Greetings colleagues!

    I recently set up replication between a Windows2000/Mssql7 server set up as distributor/publisher, and outside the firewall, an NT4/Mssql7 server.

    I tried to set up Merge replication and initially i got the error 14010 whenever i tried to push a publication from the dist./pub. to the subscriber. This i fixed by having an alias created within the domain "inside" the firewall protected area, for the server in the DMZ(which was known until then only by its IP number).
    I simply canceled the test publications and recreated them.

    At first glance everything seemed to work perfectly until i got the error for the merge agent: 20084 , subscription cannot be accepted by subscriber database, An error i understand only to appear in the case of PULL subscription, yet i had only used PUSH subscriptions from the dist./pub. server.

    I have to admit i'm mystified by this error, and having perused books online, Microsoft/technet and other sources i'm no closer to solving the problem.

    I would really appreciated any help in fixing the problem and get my replication running.
    Thank you very much, Vincent Seghers, Programmer-Analyst
    Gent.be

  2. #2
    Join Date
    Jun 2002
    Location
    Belgium
    Posts
    43

    MsSql7 merge replication error 14010

    The problem turned out to be a reference to a server on its actual IP "name" and not its nam. I declared an Alias (lettername short, no special characters) in the Client Network utility and it worked fine from then on.

    Originally posted by VincentJS
    Greetings colleagues!

    I recently set up replication between a Windows2000/Mssql7 server set up as distributor/publisher, and outside the firewall, an NT4/Mssql7 server.

    I tried to set up Merge replication and initially i got the error 14010 whenever i tried to push a publication from the dist./pub. to the subscriber. This i fixed by having an alias created within the domain "inside" the firewall protected area, for the server in the DMZ(which was known until then only by its IP number).
    I simply canceled the test publications and recreated them.

    At first glance everything seemed to work perfectly until i got the error for the merge agent: 20084 , subscription cannot be accepted by subscriber database, An error i understand only to appear in the case of PULL subscription, yet i had only used PUSH subscriptions from the dist./pub. server.

    I have to admit i'm mystified by this error, and having perused books online, Microsoft/technet and other sources i'm no closer to solving the problem.

    I would really appreciated any help in fixing the problem and get my replication running.
    Thank you very much, Vincent Seghers, Programmer-Analyst
    Gent.be

Posting Permissions

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