Forum Discussion

BrianDrought's avatar
BrianDrought
New Member
3 years ago

Reading from SQL Managed Instance Read Only Replica via 'On Premise' SQL Data Gateway

Hi Folks,   Trying to set my Data Flows to pull data from the Read Only replica of my Azure SQL MI cluster (Business Critical SKU). For regular SQL I simply throw 'ApplicationIntent=ReadOnly' on th...
Need Help
DennesTorres's avatar
DennesTorres
Icon for Power Participant rankPower Participant
3 years ago

Hi,

This link contains details about the support of this connectionstring property. This would be the first thing I would check: https://techcommunity.microsoft.com/t5/sql-server-support-blog/connect-to-sql-server-using-application-intent-read-only/ba-p/317758

"SQL Native Access Client Supports Application Intent property

 

Support for read-only routing of SQL connections is via the SQL Native Access Client provider (SNAC) version 11. You can specify the Application Intent connection property when connecting to SQL Server via SQLClient, SNAC ODBC or SNAC OLEDB.

 

The SNAC provider must be installed where your client application runs."

 

This other link: https://dba.stackexchange.com/questions/162347/alwayson-secondary-readable-cant-connect-with-applicationintent-readonly

Reminds how you need to change the AG configuration to allow the read only connections, otherwise the connectionstring setting would not work.

Kind Regards,

 

Dennes