Can we route read-only connection to readable secondary replica without setting connection string (ApplicationIntent = ReadOnly)?
Sql-server – SQL Server ReadOnly Routing Connection String
availability-groupshigh-availabilitysql serversql-server-2016
Related Question
- Sql-server – Always On read-intent
- Sql-server – How to let particular logins to work on the secondary replica only
- Sql-server – SQL Server Connection property applicationIntent
- Sql-server – AlwaysON AG Readable Secondary is set to ‘Yes’. How to connect from the client
- Sql-server – Prevent read access on primary AG replica, but allow it on the readable secondary
- Sql-server – Sql server/azure connection string parameter for readonly access
- Sql-server – SQL server AlwaysOn alternate option for readintent=true
Best Answer
You would be required to set the Secondary Replica Copy as Readable, different from Read-Intent, and point the connection string to the actual instance where the replica resides.
This is not advisable, as it negates the HA usability of any Read-Intent replicas during failover.