Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

D365 On-premises deployment - Availability Group on SQL Standard

(0) ShareShare
ReportReport
Posted on by 217

Hi,

I'm deploying SQL Server Standard for a D365 FO Production Environment with 100 users. The sandbox was deployed with a single instance SQL Server so the installation was easy.

Microsoft recommends Availability groups for Production environments. The ConfigTemplate.xml has a placeholder for the SQL Cluster and the commented section reads 'Update the ListenerName with the Always-On Availability group of your SQL cluster'.

The questions are:

  1. When I'm setting up SQL Server for the first time it does not have any User databases - so how do I create an availability group? If I cannot create an AG then how do I assign a Listener to it? 
  2. I have SQL standard licenses, therefore I can setup a Basic Availability group, which can be used for AXDB (1 db allowed in Basic AG). Does that suffice the AG requirement?

Appreciate any help. Thank you.

  • Mandeep.S Profile Picture
    Mandeep.S 217 on at
    RE: D365 On-premises deployment - Availability Group on SQL Standard

    Dear Gokul,

    Yes, I did find a solution.

    Go through this link - learn.microsoft.com/.../select-initial-data-synchronization-page-always-on-availability-group-wizards

    and this...

    learn.microsoft.com/.../select-initial-data-synchronization-page-always-on-availability-group-wizards

    You can create an empty AG and add db manually.

  • Gokul.S Profile Picture
    Gokul.S 70 on at
    RE: D365 On-premises deployment - Availability Group on SQL Standard

    Hi Mandeep Singh,

    Have you found any solution for this?

    I need to create a production environment(on-prem) with 2 sql server, i wanna need to setup availability group, how did you acheive this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans