Hello,
Microsoft SQL Server supports a read only connection when using availability groups:
https://techcommunity.microsoft.com/t5/sql-server-support-blog/connect-to-sql-server-using-application-intent-read-only/ba-p/317758https://techcommunity.microsoft.com/t5/sql-server-support-blog/connect-to-sql-server-using-application-intent-read-only/ba-p/317758
You have to add " ;applicationintent=readonly" to the connection string to enable the read only mode and get on the second replica.
Does FireDAC support this?