{ ... "resources": [ { "apiVersion": "2015-08-01", "name": "[variables('hostingPlanName')]", "type": "Microsoft.Web/serverfarms", "location": "[resourceGroup().location]", "properties": { "name": "[variables('hostingPlanName')]" }, "sku": { "name": "[parameters('hostingPlanSkuName')]", "capacity": "[parameters('hostingPlanSkuCapacity')]" }, "tags": { "displayName": "HostingPlan" } }, { "apiVersion": "2014-04-01-preview", "name": "[variables('sqlserverName')]", "type": "Microsoft.Sql/servers", "location": "[resourceGroup().location]", "properties": { "administratorLogin": "[variables('sqlserverAdminLogin')]", "administratorLoginPassword": "[variables('sqlserverAdminPassword')]" }, "tags": { "displayName": "SqlServer" }, "resources": [ { "apiVersion": "2014-04-01-preview", "name": "[variables('databaseName')]", "type": "databases", "location": "[resourceGroup().location]", "dependsOn": [ "[concat('Microsoft.Sql/servers/', variables('sqlserverName'))]" ], "properties": { "edition": "[parameters('databaseEdition')]", "collation": "[parameters('databaseCollation')]", "maxSizeBytes": "[parameters('databaseMaxSizeBytes')]", "requestedServiceObjectiveName": "[parameters('databaseRequestedServiceObjectiveName')]" }, "tags": { "displayName": "Database" } }, { "apiVersion": "2014-04-01-preview", "name": "AllowAllWindowsAzureIps", "type": "firewallrules", "location": "[resourceGroup().location]", "dependsOn": [ "[resourceId('Microsoft.Sql/servers', variables('sqlserverName'))]" ], "properties": { "startIpAddress": "0.0.0.0", "endIpAddress": "0.0.0.0" } } ] }, { "apiVersion": "2015-08-01", "name": "[variables('websiteName')]", "type": "Microsoft.Web/sites", "location": "[resourceGroup().location]", "dependsOn": [ "[concat('Microsoft.Web/serverFarms/', variables('hostingPlanName'))]" ], "properties": { "name": "[variables('websiteName')]", "serverFarmId": "[resourceId('Microsoft.Web/serverfarms', variables('hostingPlanName'))]" }, "tags": { "[concat('hidden-related:', resourceGroup().id, '/providers/Microsoft.Web/serverfarms/', variables('hostingPlanName'))]": "empty", "displayName": "Website" }, "resources": [ { "apiVersion": "2015-08-01", "name": "connectionstrings", "type": "config", "dependsOn": [ "[resourceId('Microsoft.Web/sites', variables('websiteName'))]" ], "properties": { "MyDbConnectionString": { "value": "[concat('Data Source=tcp:', reference(concat('Microsoft.Sql/servers/', variables('sqlserverName'))).fullyQualifiedDomainName, ',1433;Initial Catalog=', variables('databaseName'), ';User Id=', variables('sqlserverAdminLogin'), '@', variables('sqlserverName'), ';Password=', variables('sqlserverAdminPassword'), ';')]", "type": "SQLServer" } } } ] } ] ... }