SCOM 2007 RMS server having critical health state due to SQL Broker


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


3. Restart the Ops Manager services.

Now run the original query again and you should see a 1 telling you the service is enabled.

Comments (0)

Skip to main content