The Azure Quickstart templates are currently available in English
SQL Server 2014 SP1 Enterprise all SQL VM features enabled
Laatst bijgewerkt: 10-8-2018
This template will create a SQL Server 2014 SP1 Enterprise edition with Auto Patching, Auto Backup and Azure Key Vault Integration features enabled.
Deze ARM-sjabloon (Azure Resource Manager) is gemaakt door een lid van de community, niet door Microsoft. Elke ARM-sjabloon wordt aan u in licentie gegeven onder een licentieovereenkomst van de eigenaar, niet van Microsoft. Microsoft is niet verantwoordelijk voor ARM-sjablonen die door communityleden worden verstrekt en in licentie worden gegeven, en test deze sjablonen ook niet op veiligheid, compatibiliteit of prestaties. ARM-sjablonen van de community worden onder geen enkel programma of geen enkele service van Microsoft ondersteund, en worden 'AS IS' beschikbaar gesteld, zonder enige vorm van garantie.
Parameters
Parameternaam | Beschrijving |
---|---|
virtualMachineName | SQL Server Virtual Machine Name |
virtualMachineSize | SQL Server Virtual Machine Size |
adminUsername | SQL Server Virtual Machine Administrator User Name |
adminPassword | SQL Server Virtual Machine Administrator Password |
storageAccountName | SQL Server Virtual Machine Storage Account Name |
storageAccountType | SQL Server Virtual Machine Storage Account Type |
virtualNetworkName | SQL Server Virtual Machine Virtual Network Name |
networkInterfaceName | SQL Server Virtual Machine Network Interface Name |
networkSecurityGroupName | SQL Server Virtual Machine Network Security Group Name |
addressPrefix | SQL Server Virtual Machine Subnet Name |
subnetName | SQL Server Virtual Machine Subnet Name |
subnetPrefix | SQL Server Virtual Machine Subnet Name |
publicIpAddressName | SQL Server Virtual Machine Public IP Address Name |
publicIpAddressType | SQL Server Virtual Machine Public IP Address Type |
sqlConnectivityType | SQL Server Virtual Machine SQL Connectivity Type |
sqlPortNumber | SQL Server Virtual Machine SQL Port Number |
sqlStorageDisksCount | SQL Server Virtual Machine Data Disk Count |
sqlStorageWorkloadType | SQL Server Virtual Machine Workload Type: GENERAL - general work load; DW - datawear house work load; OLTP - Transactional processing work load |
sqlAutopatchingDayOfWeek | SQL Server Auto Patching Day of A Week |
sqlAutopatchingStartHour | SQL Server Auto Patching Starting Hour |
sqlAutopatchingWindowDuration | SQL Server Auto Patching Duration Window in minutes |
sqlAutobackupRetentionPeriod | SQL Server Auto Backup Retention Period |
sqlAutobackupStorageAccountName | SQL Server Auto Backup Storage Account Name |
sqlAutobackupEncryptionPassword | SQL Server Auto Backup Encryption Password |
sqlAkvCredentialName | SQL credential name to create on the SQL Server virtual machine |
sqlAkvUrl | Azure Key Vault URL |
sqlAkvPrincipalName | Azure Key Vault principal name or id |
sqlAkvPrincipalSecret | Azure Key Vault principal secret |
sqlAuthenticationLogin | SQL Server Authentication Login Account Name |
sqlAuthenticationPassword | SQL Server Authentication Login Account Password |
location | Location for all resources. |
De sjabloon gebruiken
PowerShell
New-AzResourceGroup -Name <resource-group-name> -Location <resource-group-location> #use this command when you need to create a new resource group for your deploymentAzure PowerShell installeren en configureren
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/301-vm-sql-full-autobackup-autopatching-keyvault/azuredeploy.json
Opdrachtregel
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 deploymentDe platformoverschrijdende Azure-opdrachregelinterface installeren en configureren
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/301-vm-sql-full-autobackup-autopatching-keyvault/azuredeploy.json