-
Title
Unable to demote database from the Publisher role or delete Subscribers -
Description
When attempting to demote the Publisher to Standalone in the Active Roles Console, the following error message is produced:
- "The role has members. It must be empty before it can be dropped"
- "Failed to modify the object 'CN=Server,CN=Configuration Databases,CN=Server Configuration,CN=Configuration' "
When attempting to delete a Subscriber from the Active Roles Console, the following error message is produced:- "Server is not defined as a Subscriber for 'Server Publisher' The Subscription could not be dropped."
- "Failed to delete the object 'CN=Server,CN=Configuration Databases,CN=Server Configuration,CN=Configuration'"
-
Resolution
*Note: The process described below will remove replication from all Active Roles databases. It is strongly advised to back up your SQL databases as well as the SQL server before performing this operation.
Run the SQL stored procedure sp_removebreplication against all Active Roles databases participating in replication, including both the Configuration and Management History databases, for all publishers and subscribers.
example:
Use [Database Name]EXEC sp_removedbreplicationgoOnce completed against all Active Roles databases, all servers will be in a standalone mode. You can now promote the publisher and re-add subscribers if desired.