Provision a Mobile App with a SQL Database

Last updated: 17-02-2016

This template provisions a Mobile App, SQL Database, and Notification Hub. It configures a connection string in the mobile app for the database and notification hub.

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
appName The name of the mobile app that you wish to create.
hostingPlanSettings The settings of the existing hosting plan.
sqlServerAdminLogin The account name to use for the database server administrator.
sqlServerAdminPassword The password to use for the database server administrator.
sqlDatabaseEdition The type of database to create.
sqlDatabaseCollation The database collation for governing the proper use of characters.
sqlDatabaseMaxSizeBytes The maximum size, in bytes, for the database
location Location for all resources.

Use the template


New-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri
Install and configure Azure PowerShell

Command line

azure config mode arm
azure group deployment create <my-resource-group> <my-deployment-name> --template-uri
Install and Configure the Azure Cross-Platform Command-Line Interface