MSSQL 2014: The SQL Server Service Broker or Database Mirroring transport is disabled or not configured

Microsoft.SQLServer.2014.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule (Rule)

The rule triggers an alert when the SQL Server Service Broker or Database Mirroring transport is disabled or not configured. Note: This rule is disabled by default. Please use overrides to enable it when necessary.

Knowledge Base article:

Summary

The SQL Server Service Broker or Database Mirroring endpoint is disabled or not configured.

Causes

This event is logged in the Windows application log as MSSQLSERVER event ID 9666. The Database Mirroring and Service Broker transport related error message is triggered even if Service Broker or Data Mirroring is not enabled. This is because the communication stack on which these features depend is started when SQL Server starts. Service Broker will not work if transport is disabled.

Resolutions

This issue may be resolved by:

Either creating the endpoint or enabling it. To create the endpoint, use the CREATE ENDPOINT statement. To enable the endpoint, use the ALTER ENDPOINT statement.
Disabling this rule using overrides for this specific database or all databases.

External

For information about creating an endpoint, see " CREATE ENDPOINT (Transact-SQL) " in Microsoft SQL Server Books Online.

For information about altering an endpoint, see " ALTER ENDPOINT (Transact-SQL) " in Microsoft SQL Server Books Online.

For more information about Database Mirroring, see the " Database Mirroring Endpoint " in the Microsoft SQL Server Books Online.

If this rule is not a concern for the database:

Disable the rule for this specific database or all databases

Overrideable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	No
Priority	Defines Alert Priority.	2
Severity	Defines Alert Severity.	2

Element properties:

Target

Microsoft.SQLServer.2014.DBEngine

Category

EventCollection

Enabled

False

Event_ID

9666

Event Source

$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/ServiceName$

Alert Generate

True

Alert Severity

Error

Alert Priority

High

Remotable

True

Alert Message

MSSQL 2014: The SQL Server Service Broker or Database Mirroring transport is disabled or not configured

{0}

Event Log

Application

Comment

Mom2014ID='{72CCDDCE-20A4-49C9-BABB-614E0D197915}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID	Module Type	TypeId	RunAs
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_	DataSource	Microsoft.Windows.EventProvider	Default
GenerateAlert	WriteAction	System.Health.GenerateAlert	Default

Source Code:

<Rule ID="Microsoft.SQLServer.2014.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule" Target="SQL2014Core!Microsoft.SQLServer.2014.DBEngine" Enabled="false" ConfirmDelivery="true" Remotable="true" Comment="Mom2014ID='{72CCDDCE-20A4-49C9-BABB-614E0D197915}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F6DA1507_12AF_11D3_AB21_00A0C98620CE_" Comment="{F6DA1507-12AF-11D3-AB21-00A0C98620CE}" TypeID="Windows!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>9666</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/ServiceName$</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="SystemHealth!System.Health.GenerateAlert">

      <Priority>2</Priority>

      <Severity>2</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2014.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>Event ID: $Data/EventDisplayNumber$. $Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>