In this blog post, let’s learn about the error message “47114 – Availability replica ‘%.*ls’ cannot be added to availability group ‘%.*ls’. Configuration-only replicas can only be added to availability groups with CLUSTER_TYPE = EXTERNAL. Verify that the AVAILABILITY_MODE setting of the replica spec, then retry the operation.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
47114 – Availability replica ‘%.*ls’ cannot be added to availability group ‘%.*ls’. Configuration-only replicas can only be added to availability groups with CLUSTER_TYPE = EXTERNAL. Verify that the AVAILABILITY_MODE setting of the replica spec, then retry the operation.
Reason for the Error
To be update soon…
Solution
To be update soon…