ConfigMgr: Prerequisite check error when upgrading 2002 to latest version – SQL Server Configuration for site upgrade failed Checks if the specified SQL Server meets the minimum requirements for site upgrade

ERROR: Invalid configuration for 'Service broker is enabled', to remediate: Use ALTER DATABASE to set ENABLE_BROKER. Today will be sharing very unique error. Normally this type error has not reported.

By doing more analysis log files (CMUpdate.log) I found out that the Prerequisite checker where SQL Service Broker on the DB. By seeing closer look it turned out to be disabled. I ran the following SQL query to confirm it.

SELECT is_broker_enabled FROM sys.databases WHERE name = 'CM_P01';

Result 0 it meaning Broker is disable. 

Then to enabled it I ran the following SQL Query.

ALTER DATABASE CM_P01 SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

Last step: To validate i have ran the first SQL query again, confirming that Service Broker was enabled.
SELECT is_broker_enabled FROM sys.databases WHERE name = 'CM_P01';

When I ran the prerequisite check again no errors to be displayed and I am able to initiate the upgrade which ran successfully.

Happy learning!!!

Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr