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:
- 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?
- 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.