IIS VMs & SQL Server 2014 VM.

Last updated: 08/05/2017

Cost estimate


Estimated monthly cost

Understand how this was calculated and customise it to your needs

Pricing calculator

Create 1 or 2 IIS Windows 2012 R2 Web Servers and one back end SQL Server 2014 in VNET.

This Azure Resource Manager (ARM) template was created by a member of the community and not by Microsoft. Each ARM template is licensed to you under a licence agreement by its owner, not Microsoft. Microsoft is not responsible for ARM templates provided and licensed by community members and does not screen for security, compatibility or performance. Community ARM templates are not supported under any Microsoft support programme or service, and are made available AS IS without warranty of any kind.


Parameter Name Description
_artifactsLocation The base URI where artifacts required by this template are located. When the template is deployed using the accompanying scripts, a private location in the subscription will be used and this value will be automatically generated.
_artifactsLocationSasToken The sasToken required to access _artifactsLocation. When the template is deployed using the accompanying scripts, a sasToken will be automatically generated.
envPrefixName Prefix for the environment (2-5 characters)
username SQL IaaS VM local administrator username
password SQL IaaS VM local administrator password
webSrvVMSize The size of the Web Server VMs Created
numberOfWebSrvs Number of Web Servers
sqlVMSize The size of the SQL VM Created
storageAccountType The type of the Storage Account created

Use the template


New-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/iis-2vm-sql-1vm/azuredeploy.json
Installing and configuring Azure PowerShell

Command line

azure config mode arm
azure group deployment create <my-resource-group> <my-deployment-name> --template-uri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/iis-2vm-sql-1vm/azuredeploy.json
Installing and configuring the Azure cross-platform command-line interface