SCCM SQL Server Configuration for site upgrade Failed

SCCM SQL Server Configuration for site upgrade Failed. I got the following error when doing the prerequisite check in SCCM prior to a KB installation.

SQL Server Configuration for site upgrade
[Failed]:Checks if the specified SQL Server meets the minimum requirments for site upgrade

The log files (CMUpdate.log) say it kicking on with the SQL Service Broker on the Database. Run the following SQL query to check it out:

SELECT is_broker_enabled FROM sys.databases WHERE name = '<DatabaseName>';

Then to enable it, exécutez ce qui suit:

ALTER DATABASE <DtabaseName> SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

Run the first SQL query again to confirm that the SQL Service Broker was enabled:

SELECT is_broker_enabled FROM sys.databases WHERE name = '<DatabaseName>';

After that KB installation prerequisite checks completed successfully.