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
X
2 Comments
Karsten Asak-Gyldenås
02-09-2021 07:38 amYou absolute champion! Thanks!
Haresh Hirani
Thanks for update
Shamshad KP
27-07-2022 06:54 pmQuick and Easy fix Bhai... keep rocking