An alert from this monitor and a critical state indicate that SQL Broker is misconfigured for the Operations Manager Operational Database. Please see the Resolutions section on how to remediate this condition.

This can be caused by someone disabling SQL Broker for the Operations Manager Operational Database or a configuration error.

Follow the below steps to remediate this problem.

• Stop the following services on the Management Server: OMSDK, OMCFG, HealthService

• Open SQL Studio

• Connect to the server that hosts the Operations Manager Operational Database

• Create a new query

• Type "ALTER DATABASE OperationsManager SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;"

• Execute this query

• If the query is successful, you should see a return value of "0"

• Start the following services on the Management Server: OMSDK, OMCFG, HealthService

• Wait until the monitor runs again, or force the monitor to recalculate.

• The state should return to Healthy and the alert should be autoresolved.