Thanks last week first of all for your assistance in getting a quick setup for a third replica in our Always On system 🙂
Problem I have now is baffling me. We have the Primary and one Secondary on subnet A, the (new, remote) Secondary on subnet B. They all are set to Read-Intent only when they are Secondaries but when application users connect using the relevant string no matter what they always connect to the Primary and not one of the Secondaries.
I am told this wasn't the case a few weeks ago so looked into any SQL patching or config changes but nothing correlates with the issue first appearing. The SQL Listener has the IP address of the current Primary as well as the new Secondary, the URLs and routing list for each node all look correct (happy to post abstracted screen shots on request).
I thought I was quite good on things Always On, maybe am missing something obvious but your advice and assistance would be much appreciated; for now the Dev DBA has added a workaround to the application that does the Reporting (checks for Primary and manually redirects to one of the other nodes) but this is only a short-term fix.
Thanks in advance!