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

  • Article

CAUSE:
======

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.