I have read only routing setup and working fine. I have a SQL login that accesses the readable secondary via the listener using
ApplicationIntent=ReadOnly. However I want to prevent the user from accessing the primary.
I have seen a lot of topics on this and they all seem to suggest disabling the login on the primary. When I do this connections to the listener with
ApplicationIntent=ReadOnly fail with
Login failed for user ''. Reason: The account is disabled.
I have ensured the accounts are the same SID.
Thanks for any help.