I configured SQL Server AlwaysOn to redirect Read-Only to Secondary and tried to check with
ApplicationIntent=ReadOnly setting in SSMS by connecting to the Listener. But my connection is always going to Primary only as revealed by
Does anyone know what is wrong with the settings or reason for this? I checked altering the settings but didn't work.
SQL Server 2017
AG Properties Using Admin account to test the routing.