Microsoft Azure has a new subscription offering, CSP Subscriptions. Some aspects of SQL VM deployment are not yet supported in CSP subscriptions. This includes the SQL IaaS Agent Extension, which is required for features such as SQL Automated Backup and SQL Automated Patching.
此 Azure Resource Manager (ARM) 模板由社区的某个成员（而不是由 Microsoft）创建。每个 ARM 模板都根据其所有者（不是 Microsoft）的许可协议向你授予许可。Microsoft 不对由社区成员提供并授予许可的 ARM 模板负责，并且不针对安全性、兼容性和性能进行筛选。社区 ARM 模板不由任何 Microsoft 支持计划或服务提供支持，按“原样”提供，没有任何种类的担保。
参数
| 参数名 | 说明 |
|---|---|
| vmName | SQL IaaS VM machine name |
| vmSize | SQL IaaS VM size. Use Azure VM size name from MSDN |
| sqlImageOffer | SQL Server Gallery Image Offer |
| sqlImageSku | SQL Server Gallery Image SKU |
| sqlImageVersion | SQL Server Gallery Image Published Version |
| username | SQL IaaS VM local administrator username |
| password | SQL IaaS VM local administrator password |
| storageName | SQL IaaS VM data and OS disks storage service |
| storageType | SQL IaaS VM data and OS disks storage type |
| vnetName | SQL IaaS VM virtual network name |
| networkAddressSpace | SQL IaaS VM virtual network IPv4 address space |
| subnetName | SQL IaaS VM virtual network subnet name |
| subnetAddressPrefix | SQL IaaS VM virtual network subnet IPv4 address prefix |
| publicDnsName | DNS name for the VM |
| location | Location for all resources. |
使用模板
PowerShell
New-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/sqlvm-provisioning-csp/azuredeploy.json安装和配置 Azure PowerShell
命令行
azure config mode arm安装和配置 Azure 跨平台命令行界面
azure group deployment create <my-resource-group> <my-deployment-name> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/sqlvm-provisioning-csp/azuredeploy.json