In this blog post, let’s learn about the error message “41428 – This secondary replica is not joined to the availability group. For an availability replica to be successfully joined to the availability group, the join state must be Joined Standalone Instance (1) or Joined Failover Cluster (2). For information about how-to join a secondary replica to an availability group, see SQL Server Books Online.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
41428 – This secondary replica is not joined to the availability group. For an availability replica to be successfully joined to the availability group, the join state must be Joined Standalone Instance (1) or Joined Failover Cluster (2). For information about how-to join a secondary replica to an availability group, see SQL Server Books Online.
Reason for the Error
To be update soon…
Solution
To be update soon…