Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Update MSCRM_DataSourc...

Update MSCRM_DataSource Connection string in CustomReports Folder to add ApplicationIntent=ReadOnly

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

We are on CRM 2015 On Premesis, and our MS SQL Server is setup with two replicas in an Always On Availability Group. I've enabled Read Only Routing so Intent Read Only connections will go to the Passive Replica, and I'd like to setup the CRM SQL Reports to use the Passive Replica. Problem is when I go into the CustomReport folder and edit MSCRM_DataSource the Data Source Type is 'Microsoft Dynamics CRM SQL' and Connection String is 'MSCRM Data Connector Connection String'. I did update MSCRM_DataSource in the Organization folder (same folder as the CustomReport folder), but apparently this isn't used by Custom Reports.

How can I update the connection string for Custom Reports to add ApplicationIntent=ReadOnly ? Or is the only option to create a new data source in the CustomReport folder with a direct connection to the AG? Also note this is only for SQL Reports using Filtered Views, not FetchXML Reports.

Thanks.

*This post is locked for comments

All responses (3)

Answers (0)

Jewell_IT 5 on at

Like (0)

Report

RE: Update MSCRM_DataSource Connection string in CustomReports Folder to add ApplicationIntent=ReadOnly

I guess it's my turn this year - Any one have an answer to this? Hoping to implement a solution while upgrading to On-Prem version 9. Thanks,
Community Member Microsoft Employee on at

Like (0)

Report

RE: Update MSCRM_DataSource Connection string in CustomReports Folder to add ApplicationIntent=ReadOnly

Did you ever find an answer for this? I'll be doing the same for our 365 On-Prem deployment. Any response is appreciated. Thanks.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Update MSCRM_DataSource Connection string in CustomReports Folder to add ApplicationIntent=ReadOnly

I am also having the same issue. Did you ever find a fix for this or does anyone else have any ideas?