The SQL Server Service Broker or Database Mirroring transport is disabled or not configured
The alert “The SQL Server Service Broker or Database Mirroring transport is disabled or not configured” is one that pops up in new installations quite frequently. A typical answer is to look at the Broker part and check if it is set as in this post.
With SQL 2008 you do not have to run the SQL query as it is shown in the properties of the database. Open SQL Server Management Studio, select OperationsManager database and right click and chose Properties. Click Options and scroll down and there is a section called Service Broker.
On my default install this is set to true anyway. But the clue is in the alert. In the alert details it says “The Database Mirroring protocol transport is disabled or not configured.” Back in the database properties under Mirroring we can see that the database has not been configured for mirroring.
If you select Configure Security you will see the following error message.
In my test environment the database had defaulted to Simple Recovery Model. There are three – Simple, Full and Bulk-Logged. This is fine for a test environment but is unlikely in a production environment. With the Recovery Model at Simple you will need to override this SQL MP alert. It would have been nice if they had created two rules for this instead on just the one.