Error 20736 while setting up merge replication in SQL Server 2000
Posted on 2008-10-30
I'm trying to setup a merge replication for a database (name is eeq_ann) in SQL Server 2000.
I got the problem before so I tried a clean install and I still have the trouble.
I create a distributor for my server without any problem. Now I try to setup a new publication so I use "new publication" in the Enterprise Manager.
I see my database 'eeq_ann', select the table I want to replicate, etc. then I create the publication. However, during the publication creation process, there is an error :
SQL Server Enterprise Manager could not create publication 'eeq_ann' from database 'eeq_ann'
Error 20736: [SQL-DMO]This object has been dropped from the server.
After that, if I go to create a new publication, I cannot select my database as the system somehow thinks there is one even thougth I cannot see it in the enterprise manager explorer. When I go to Tools -> Replication -> Create and Manage Publications, I can see it in the tree view but I cannot delete it.
So I tried to delete it manually using the following :
exec sp_dropmergepublication @publication=N'eeq_ann'
exec sp_replicationdboption @dbName=N'eeq_ann',@optname=N'merge publish',@value=N'false'
it says it removed the publication and I do not see it anymore as a matter of fact. So I tried to recreate the publication, but now I get the same 20736 error in the publication wizard when I try to select a table to merge.
Thanks for the help!