In this blog post, let’s learn about the error message “19401 – The READ_ONLY_ROUTING_URL ‘%.*ls’ specified for availability replica ‘%.*ls’ is not valid. It does not follow the required format of ‘TCP://system-address:port’. For information about the correct routing URL format, see the CREATE AVAILABILITY GROUP documentation in SQL Server Books Online.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
19401 – The READ_ONLY_ROUTING_URL ‘%.*ls’ specified for availability replica ‘%.*ls’ is not valid. It does not follow the required format of ‘TCP://system-address:port’. For information about the correct routing URL format, see the CREATE AVAILABILITY GROUP documentation in SQL Server Books Online.
Reason for the Error
To be update soon…
Solution
To be update soon…