Wednesday, June 3, 2026
type here...
CM InfrastructureSCCM InstallationSCCM Infrastructure

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

By Haresh Hirani
2
4138

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.

Previous article
Content Source Migration of Migrated Applications and Packages
Next article
Windows Autopilot scenarios

2 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Search

Latest posts

I’m the person behind this webpage. Thank you for visiting the website and about me page! My website is all about Microsoft technologies. More about ConfigMgr and all other technologies which are interesting for me. However, larger percentage of my posts are related to SCCM. Normally, like to post the interesting issues which I came across in my day to day tech life. you will find only solutions which comes on my day to day life.

Hot Category

Popular Post

© COPYRIGHT Hiraniconfigmgr.com

Developed By : Deepcoder