SQL Server Error Code – 19404 an availability replica ‘%.*ls’ that is

In this blog post, you’ll learn more about the SQL Server Error Code 19404 and the error message description that is shown

SQL Server Error Code

19404

SQL Server Error Description for the Code :19404

An availability replica ‘%.*ls’ that is specified in the READ_ONLY_ROUTING_LIST for availability replica ‘%.*ls’ does not have a value set for READ_ONLY_ROUTING_URL. Ensure a READ_ONLY_ROUTING_URL is set for each availability replica in the availability group. Specify a valid READ_ONLY_ROUTING_URL for each replica that you want to added to the READ_ONLY_ROUTING_LIST. If you are altering availability replicas of an existing availability group, you can 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.