SQL Server Performance

Error in Replication

Discussion in 'SQL Server 2005 Replication' started by krajdba, Mar 1, 2006.

  1. krajdba New Member

    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
  2. satya Moderator

    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.
  3. krajdba New Member

    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

Share This Page