Blog

July 06 2009 7:43 PM

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)


 Print  

Quick Links
Top Contributors
Pete Zerger
Points: 25205
Level: System Center Expert
Simon Skinner
Points: 20303
Level: System Center Expert
Tommy Gunn
Points: 19054
Level: System Center Expert
MadHatter
Points: 11573
Level: System Center Expert
Stefan Koell
Points: 10134
Level: System Center Expert