Need Help Configuring AlwaysOn Availability Groups for Dynamics 365 v9

(0) Share

Report

Posted on by meysam

Hello

Our organization decided to change a live Dynamics 365 v9(Production Environment) database connection to an SQL server always-on availability group with SQL Listener

I researched and find this article :
https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/deployment-administrators-guide/jj822357(v=crm.8)?redirectedfrom=MSDN

But the above article is for the 2016 version and in V9, the Microsoft.Crm.SqlClr.Helper.dll is missing!

All I want is to know :

Does anyone did this before? if so, what is your secure and risk-free way to get this job done.

By risk-free, I mean no failure for the server, because we have a lot of active sessions and users working with the server.

And keep data and its integrity safe.

Thank you in advance.

I have the same question (0)

All responses (2)

Answers (0)

BB-07082110-0 on at

Like (0)

Report

I have done this before in the past. The biggest issue is the overhead for using Always on but it works flawlessly. You will definitely need to be carefully when you are patching the servers as well.

You can do testing as well. When it fails over, it usually slows down for a short span and then continues on.

There are also some YouTube videos about the subject..

Was this reply helpful? Yes No
Suggested answer

Platon Vasilchenko 4 on at

Like (0)

Report

Hello.

MSCRMSqlClrLogin SQL login, the asymmetric key for it, and Microsoft.Crm.SqlClr.Helper.dll aren’t required with Dynamics 365 Customer Engagement (on-premises), version 9.

See this article: https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/deploy/post-installation-configuration-guidelines-dynamics-365?view=op-9-0#configure-databases-for-sql-server-alwayson

Was this reply helpful? Yes No

Join the conversation

Community site session details

Need Help Configuring AlwaysOn Availability Groups for Dynamics 365 v9

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Need Help Configuring AlwaysOn Availability Groups for Dynamics 365 v9

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates