SQL Server Developer Center > SQL Server Forums > SQL Service Broker > Is Sql 2005 Service Broker be enabled by default?
Ask a questionAsk a question
 

QuestionIs Sql 2005 Service Broker be enabled by default?

  • Monday, June 29, 2009 7:18 AMbarkingdog Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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)

All Replies

  • Saturday, October 24, 2009 12:30 AMJang-uk In Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Has Code
    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.