The Azure Quickstart templates are currently available in English

Create a SQL Server AlwaysOn Cluster Deployment

上次更新日期: 2018/9/11

This template creates 5 new Azure VMs, each group load balancer and a VNet. It configures a primary and backup AD Domain Controller for a new Forest and Domain, two SQL Servers and witness in AlwaysOn configuration

此 Azure Resource Manager (ARM) 範本是由社群成員 (而非 Microsoft) 建立。每個 ARM 範本都是由其擁有者 (而非 Microsoft) 依據授權合約授權給您。Microsoft 並不負責社群成員所提供和授權的 ARM 範本,而不會為了安全性、相容性或效能進行篩選。社群 ARM 範本並未依據任何 Microsoft 支援方案或服務提供支援,而且會在沒有任何擔保的情況下依現況提供。


參數名稱 說明
adminUsername The name of the Administrator of the new VMs and Domain
adminPassword The password for the Administrator account of the new VMs and Domain
adVMSize The size of the AD VMs Created
sqlVMSize The size of the SQL VMs Created
witnessVMSize The size of the Witness VM Created
domainName The FQDN of the AD Domain created
sqlServerServiceAccountUserName The SQL Server Service Account name
sqlServerServiceAccountPassword The SQL Server Service Account password
sqlStorageAccountName The name of Sql Server Storage Account
sqlStorageAccountType The type of the Sql Server Storage Account created
dcStorageAccountName The name of DC Storage Account
dcStorageAccountType The type of the DC Storage Account created
virtualNetworkAddressRange The address range of the new VNET in CIDR format
staticSubnet The address range of the subnet static IPs are allocated from in the new VNET
sqlSubnet The address range of the SQL subnet created in the new VNET
adPDCNICIPAddress The IP address of the new AD VM
adBDCNICIPAddress The IP address of the new backup AD VM
sqlLBIPAddress The IP address of the new SQL Server Internal Load Balancer
deploymentPrefix The DNS Prefix for the Public IP Address for the Always On Cluster
virtualNetworkName Name of virtual network to be created
templatesBaseUrl Linked Templates base url
scriptsBaseUrl DSC Scripts base url
autoPatchingDay The day of a week for auto patching
autoPatchingStartHour The start hour of a day for auto patching
sqlAOAGName The Sql AlwaysOn Group Name
sqlAOListenerPort The Sql AG Listener port
sqlAOListenerName The Sql AG Listener Name
sqlServerVersion The Sql Server Version
numberOfSqlVMDisks The Sql VM Disk Size
workloadType The Sql VM work load type: GENERAL - general work load; DW - datawear house work load; OLTP - Transactional processing work load
location Location for all resources.



New-AzResourceGroup -Name <resource-group-name> -Location <resource-group-location> #use this command when you need to create a new resource group for your deployment
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri
安裝和設定 Azure PowerShell


az group create --name <resource-group-name> --location <resource-group-location> #use this command when you need to create a new resource group for your deployment
az group deployment create --resource-group <my-resource-group> --template-uri
安裝和設定 Azure 跨平台命令列介面