1

1

Alert: The SQL Server Service Broker or Database Mirroring transport is disabled or not configured.

Issue: This alert may occur even if the broker IS enabled.

Resolution: Verify the broker is enabled by running the following query in Management Studio, connected to the Master database:
SELECT is_broker_enabled FROM sys.databases WHERE name = ‘OperationsManager’
If the result=1, the broker is enabled. If result=0 enable the broker as follows:
1. Stop the SDK, Config, and Health Services on the RMS, and the Heath Service on any secondary management servers
2. Execute the following statement from SQL Management Studio
ALTER DATABASE OperationsManager SET ENABLE_BROKER
3. Restart the services

If the alert continues to reoccur, disable the rule using an override.

Update Aug 2009 - Fix for SQL 2008 is a bit different. See the following article for step-by-step fix http://ianblythmanagement.wordpress.com/2009/08/04/the-sql-server-service-broker-or-database-mirroring-transport-is-disabled-or-not-configured/

Submitted By: Kerrie Meyler (MVP)