Friday, March 9, 2012

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.beThe 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

No comments:

Post a Comment