SCCM SQL Server Configuration for site upgrade Failed

SCCM SQL Server Configuration for site upgrade Failed. I got the following erro 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

O registro 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, run the following:

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.