News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) MSCRM_CONFIG connectio...

Microsoft Dynamics CRM (Archived)

MSCRM_CONFIG connection string syntax for SQL AlwaysON Read-Only Routing

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello. I have two sql servers in an alwayson cluster. Both the primary and secondary have a secondary role of read intent. I've configured the read only url and the read only routing list.

Can anyone confirm what the syntax should be for the Organization.ConnectionString in MSCRM_CONFIG?

I tried the one below but lost connection to my orgs after about 30 minutes of running the command:

Provider=SQLOLEDB;Data Source=AGListenerName;Initial Catalog=OrgName_MSCRM;Integrated Security=SSPI;MultiSubnetFailover=True;ApplicationIntent=ReadOnly;

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: MSCRM_CONFIG connection string syntax for SQL AlwaysON Read-Only Routing

Hi Radu,

That's the article that I've read a million times when originally setting up the AlwaysOn group but it has no mention of ApplicationIntent=ReadOnly.
Suggested answer

Radu Chiribelea 6,667 on at

Like (0)

Report

RE: MSCRM_CONFIG connection string syntax for SQL AlwaysON Read-Only Routing

Hello,

Please check following link: technet.microsoft.com/.../jj822357.aspx

Hope this helps,

Radu

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans