https://catalogartifact.azureedge.net/publicartifacts/Microsoft.SQLVMHA-1.0.8/Large.png

SQL Server with High Availability

Microsoft

SQL Server with High Availability

Microsoft

Create SQL Server virtual machines in an Always On Availability Group

This solution will create new virtual machines with SQL Server, a Windows failover cluster, an Always On Availability Group, and a listener in multiple subnets. The Always On availability group feature is a high-availability solution that maximizes the availability of a set of user databases for an enterprise. An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. All deployment options enable you to bring your on-premises licenses to Azure using Azure Hybrid Benefit. There are several prerequisites needed to successfully deploy this solution including:
  • A resource group
  • A virtual network
  • A domain controllers VM in the same virtual network
  • The following account permissions:
    • A domain user account that has Create Computer Object permissions in the domain. This user will create the cluster and availability group, and will install SQL Server. For example, a domain user account (account@domain.com) typically has sufficient permission. This account should also be part of the local administrator group on each VM to create the cluster.
    • A domain SQL Server service account to control SQL Server. This should be the same account for every SQL Server VM that you want to add to the availability group.
For more information, please review docs