Skip to main content
1 of 2
user avatar
user avatar

AlwaysOn Availability Secondary replica not work as read only

We have configured SQL Server - Always On Availability group with SQL SERVER 2022 Enterprise Edition. where there is 2 instance which are also configured with Readable secondary 'Yes'. According to my little knowledge all the read queries should return data from my secondary instances, but it didn't happen.
I have attached my configuration

enter image description here

I want to active the readable secondary replica.