Wednesday, June 3, 2026

Checks if the specified SQL Server meets the minimum requirements for site upgrade

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

Author

  • Hi, I’m Haresh Hirani the mind behind Hiraniconfigmgr.com. I’m a seasoned IT professional with deep expertise in Microsoft technologies, especially in Configuration Manager (ConfigMgr/SCCM). Over the years, I’ve expanded my skill set to cover a broader range of modern device management platforms like Microsoft Intune, Jamf Pro, ManageEngine Endpoint Central, and VMware AirWatch (Workspace ONE UEM), I use this blog to document real-world, tested, working fixes and walkthroughs from my daily technical experiences. The 💡idea is simple: if it helped me, it might help someone like you. My goal is to create a living repository of practical IT solutions for the community. If you find something useful, or if you want to collaborate, feel free to connect with me on LinkedIn or drop a message through the Contact page. Happy to help.

2 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest posts