The SQL Server Service Broker or Database Mirroring endpoint is disabled or not configured.
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.
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.
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
Target | Microsoft.SQLServer.2012.DBEngine | ||
Category | EventCollection | ||
Enabled | False | ||
Event_ID | 9666 | ||
Event Source | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | High | ||
Remotable | True | ||
Alert Message |
| ||
Event Log | Application | ||
Comment | Mom2012ID='{72CCDDCE-20A4-49C9-BABB-614E0D197915}';MOM2012GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_ | DataSource | Microsoft.Windows.EventProvider | Microsoft.SQLServer.SQLDefaultAccount |
GenerateAlert | WriteAction | System.Health.GenerateAlert | Default |
<Rule ID="Microsoft.SQLServer.2012.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule" Target="SQL2012Core!Microsoft.SQLServer.2012.DBEngine" Enabled="false" ConfirmDelivery="true" Remotable="true" Comment="Mom2012ID='{72CCDDCE-20A4-49C9-BABB-614E0D197915}';MOM2012GroupID={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" RunAs="SQL!Microsoft.SQLServer.SQLDefaultAccount">
<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="SQL!Microsoft.SQLServer.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.2012.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule.AlertMessage"]$</AlertMessageId>
<AlertParameters>
<AlertParameter1>$Data/EventDescription$</AlertParameter1>
</AlertParameters>
<Suppression>
<SuppressionValue/>
</Suppression>
</WriteAction>
</WriteActions>
</Rule>