Is Sql 2005 Service Broker be enabled by default?

Question

We just installed OpsMgr 2007 on our sql 2005 database server and it complains that: "The SQL Server Service Broker or Database Mirroring transport is disabled or not configured Priority" We have not enabled Service Broker (and we don't use mirroring on this server) so I don't know what to make of that message. I read somewhere that Service Broker is enabled by default. Is that true? (In other words, does the OpsMgr message indicate a "real" problem or is it just saying it is desirable to enable Service Broker?) TIA, barkingdog (Despite the Title confusion, I am asking about a sql 2005, not sql 2008, server)

Answer 1

It is true that Service Broker is enabled by default in SQL Server 2005.  Service Broker is enabled by default when a new database is created.  Please try to run the following query to see the Broker option on a database.

CREATE DATABASE testdb;
SELECT name, is_broker_enabled FROM sys.databases;

The OpsMgr message indicates an issue about the disabled Service Broker.  OpsMgr tries to use Service Broker, but it is disabled.