There is an AGRIS-on-SQL option to run Active Reports against a read-only db.
Step 1:
Install the SQL Native Client 11.0 on the AGRIS client
Notes from Microsoft:
Install Microsoft® SQL Server® 2012 Native Client from the Microsoft® SQL Server® 2012 Feature Pack. Under the ‘Install Instructions’ link, you will find an individual link for the SQL Server 2012 Native Client.
http://www.microsoft.com/en-us/download/details.aspx?id=29065
Step 2:
Go to AGRIS\bin\commonsettings.config
Find this tag and change it to “true”
<add key="ReportsReadOnly" value= "false" />
Note that commonsettings.config file is part of the AGRIS distribution
So it gets overwritten any time you upgrade AGRIS versions (not software updates, only version upgrades)
Plan to restore this setting after upgrades
The note and link in step 1 were taken from this page. The information there is useful if you want to connect to the AGRIS db for any non-AGRIS queries. Those can also be directed to the read-only db.
https://blogs.msdn.microsoft.com/alwaysonpro/2013/08/02/connect-to-sql-server-using-application-intent-read-only/
