Connect a web app to a SQL database

In this scenario you will learn how to create an Azure SQL database and an Azure web app. Then you will link the SQL database to the web app using app settings.

If you don't have an Azure subscription, create a free account before you begin.

Launch Azure Cloud Shell

The Azure Cloud Shell is a free Bash shell that you can run directly within the Azure portal. It has the Azure CLI preinstalled and configured to use with your account. Click the Cloud Shell button on the menu in the upper-right of the Azure portal.

Cloud Shell

The button launches an interactive shell that you can use to run the steps in this topic:

Screenshot showing the Cloud Shell window in the portal

If you choose to install and use the CLI locally, this topic requires that you are running the Azure CLI version 2.0 or later. Run az --version to find the version. If you need to install or upgrade, see Install Azure CLI 2.0.

Sample script


# Variables

# Create a Resource Group 
az group create --name myResourceGroup --location $location

# Create an App Service Plan
az appservice plan create --name WebAppWithSQLPlan --resource-group myResourceGroup --location $location

# Create a Web App
az webapp create --name $appName --plan WebAppWithSQLPlan --resource-group myResourceGroup

# Create a SQL Server
az sql server create --name $serverName --resource-group myResourceGroup --location $location --admin-user $username --admin-password $sqlServerPassword

# Configure Firewall for Azure Access
az sql server firewall-rule create --resource-group myResourceGroup --server $serverName --name AllowYourIp --start-ip-address $startip --end-ip-address $endip

# Create Database on Server
az sql db create --resource-group myResourceGroup --server $serverName --name MySampleDatabase --service-objective S0

# Assign the connection string to an App Setting in the Web App
az webapp config appsettings set --settings "SQLSRV_CONNSTR=Server=tcp:$;Database=MySampleDatabase;User ID=$username@$serverName;Password=$sqlServerPassword;Trusted_Connection=False;Encrypt=True;" --name $appName --resource-group myResourceGroup

Clean up deployment

After the script sample has been run, the follow command can be used to remove the resource group and all resources associated with it.

az group delete --name myResourceGroup

Script explanation

This script uses the following commands to create a resource group, web app, SQL database and all related resources. Each command in the table links to command specific documentation.

Command Notes
az group create Creates a resource group in which all resources are stored.
az appservice plan create Creates an App Service plan. This is like a server farm for your Azure web app.
az webapp create Creates an Azure web app.
az sql server create Creates a SQL Database Server.
az sql db create Creates a new database with the SQL Database Server.
az webapp config appsettings set Creates or updates an app setting for an Azure web app. App settings are exposed as environment variables for your app.

Next steps

For more information on the Azure CLI, see Azure CLI documentation.

Additional App Service CLI script samples can be found in the Azure App Service documentation.