I want to connect a Read-Only replica for reporting purpose in Azure SQL managed instance. For this, I tried to add an ApplicationIntent=ReadOnly parameter.
But it is still it not connecting the Read-Only replica. So is there any configuration required to connect Read-Only replica in Azure MI?
Azure SQLMI Business critical service tier has Built-in additional read-only database replica that can be used for reporting and other read-only workloads similar to azure sql database premium tier. It is enabled by default no user action required. You need to use the ApplicationIntent=ReadOnly flag in the connection string to access the read-only replica.