In this blog post, let’s learn about the error message “19403 – The availability replica ‘%.*ls’ specified in the READ_ONLY_ROUTING_LIST for availability replica ‘%.*ls’ does not exist. Only availability replicas that belong to the specified availability group ‘%.*ls’ can be added to this list. To get the names of availability replicas in a given availability group, select replica_server_name from sys.availability_replicas and name from sys.availability_groups. For more information, see SQL Server Books Online.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
19403 – The availability replica ‘%.*ls’ specified in the READ_ONLY_ROUTING_LIST for availability replica ‘%.*ls’ does not exist. Only availability replicas that belong to the specified availability group ‘%.*ls’ can be added to this list. To get the names of availability replicas in a given availability group, select replica_server_name from sys.availability_replicas and name from sys.availability_groups. For more information, see SQL Server Books Online.
Reason for the Error
To be update soon…
Solution
To be update soon…