SQL Server Performance Forum – Threads Archive
Error in ReplicationHi 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."
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
Contributing Editor & Forums Moderator
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