2. Add a data connection to the Azure App Service instance

#1.

Select the "Data Connections" item from the left-hand menu of the Azure App Service instance.

#2.

Click the "➕ Add" action at the top of the panel that appears.

#3.

Make your way though each panel ("blade") in the wizard.

1. In the first panel, select "SQL Database" as the type. Click the "Configure Required Settings" action to continue.
2. Click "Create a new database" in the second panel.
3. In the third panel, name the database. Then click the "Pricing Tier" action.
4. Select whichever pricing tier makes sense for you. Basic should be sufficient for this sample app. Click "Select".

#4.

Continued from 3:

5. Returning to the third panel, click the "Target server" action.
6. If you already have an existing server, you may use it, or you may create a new one. These instructions assume you'll create a new one.
7. In the fifth panel, provide the details for the server: server name, admin username, password, regional location. Click "Select". Complete any open panels until you are navigated back to the first one.

#5.

If you click "Connection String" in the first panel, the connection string panel will appear, and should have a default value of "MS_ConnectionTableString" already populated. Click "OK" and "OK" to complete creation of the data connection.

#6.

Once complete, you should see a single data connection now listed.