I'm trying to understand the read options for secondary replicas in Always On.
When I set the Readable Secondary option to 'Read-intent only' I cannot open the secondary database to read data in management studio
However when I select 'Yes' I am able to read from the secondary database.
Is it only possible to read from a secondary replica in management studio if you set the Readable Secondary option to 'Yes'?
What is the difference between Read Intent Only and Yes?