TechNet
Export (0) Print
Expand All

Availability replica is disconnected

 

Published: May 17, 2016

Updated: May 17, 2016

Applies To: SQL Server 2016

Policy NameAvailability Replica Connection State
IssueAvailability replica is disconnected.
CategoryCritical
FacetAvailability replica

This policy checks the connection state between availability replicas. The policy is in an unhealthy state when the connection state of the availability replica is DISCONNECTED. The policy is otherwise in a healthy state.

System_CAPS_ICON_note.jpg Note


For this release of SQL Server 2016, information about possible causes and solutions is located at Availability replica is disconnected on the TechNet Wiki.

The secondary replica is not connected to the primary replica. The connected state is DISCONNECTED. This issue can be caused by the following:

  • The connection port might be in conflict with another application.

  • The encryption type or algorithm is mismatched.

  • The connection endpoint has been deleted or has not been started.

  • The transport is disconnected.

Following are possible solutions for this issue:

  • Check the database mirroring endpoint configuration for the instances of the primary and secondary replica and update the mismatched configuration.

  • Check if the port is conflicting, and if so, change the port number.

Overview of Always On Availability Groups (SQL Server)
Use the Always On Dashboard (SQL Server Management Studio)

Community Additions

ADD
Show:
© 2016 Microsoft