SQL Broker was not enabled on the Operations Manager database
The SQL Server Broker Service can be checked with the following query.
Open SQL Management Studio the select New Query
Type: SELECT is_broker_enabled FROM sys.databases WHERE name =’OperationsManager’
Execute the query.
If the results return a 0 then the Broker Service is disabled.
To enable the service execute the following:
1. Stop all of the Ops Manager services on the RMS and other management servers.
***Note**** if you don’t stop the services before you run the query it executes forever (hangs).
2. Re-enable the broker
ALTER DATABASE OperationsManager SET ENABLE_BROKER
3. Restart the Ops Manager services.
Now run the original query again and you should see a 1 telling you the service is enabled.