SQL Broker was not enabled on the Operations Manager database
Resolution: ========== 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.