I only read routing setup and works fine. I have an SQL login that accesses the readable secondary via the listener
ApplicationIntent = ReadOnly, However, I want to prevent the user from accessing the primary database.
I have seen a lot of topics on this topic and they all seem to encourage disabling the login on the primary server. If I make these connections to the listener
ApplicationIntent = ReadOnly fail with
Login failed for user & # 39; & # 39 ;. Reason: The account is disabled.
I have made sure that the accounts are the same SID.
Thanks for any help.