Today, I worked on a service request that our customer wants to use the parameter of ApplicationIntent=ReadyOnly to connect to the secondary replica of Transparent Failover Group. Unfortunately, it doesn't work because ApplicationIntent has other purpose for Azure SQL DB and Managed Instance, I would like to explain it below.
1) Remember that every time that you create a Premium or Business Critical database in Azure SQL Database or Business Critical for Azure SQL Managed Instance will be created two additional replicas that will be synced using AlwaysOn environment.
2) If you want to connect to any of these replicas, basically, you need to add in the connection string the parameter ApplicationIntent=Readonly - https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out
3) If you have a Transparent Failover Group defined and you specify ApplicationIntent=Readonly in the connection string, the result will be that you are going to connect to any replica of the server that is the primary (ReadScale Out) and will not routed to the secondary server. Let me share with you an example:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.