Error in Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error in Replication

Hi I am getting following error,while replicating.Please let me know how to fix it…
"SQL Server Enterprise Manager could not configure the OCSBUILD as the Distributor for "OCSBUILD". Error 21045 :Cannnot Uninstall the Distributor because there are databases enabled for publishing or merge publishing."
Thanks. raj
Are you trying to remove the replication?
As the error seems to try removing the replication. If so try running these commands on each database then hopefully you’ll be able to uninstall the distributor and restart.
exec sp_dboption ‘yourdb’,’published’,false
exec sp_dboption ‘yourdb’,’merge publish’,false
Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Now, I am getting this error…
SQL Server Enterprise Manager could not configure ‘poeticserver’ as the Distributor for Poeticserver Error 14114: ‘(NULL)’ is not configured as a Distributor. Please help. Thanks
raj
]]>