Skip to content

create azure web app with sql

lyuben kikov edited this page Feb 8, 2018 · 2 revisions

Back to Home


Creating web app on Azure with SQL support.

  • Make sure you have account.
  • Step 1: Navigate to portal.azure.com
  • Step 2: From the side menu select New
  • Step 3: Search for WebApp + SQL suggestion

  • If you already have configured service plan, you can choose it and work with it. Otherwise you should create one for free.
  • Once you have found and choose the Web App + SQL option... on the next screens just follow the steps.
  • Step 1: Clicked on Create button
  • Step 2: Give meaningful name for your app
  • Step 3: Choose App Service plan/Location option and hit Create new

Once you give meaningful name for your app service plan, be sure that you've select F1 Free tier. Otherwise you might be charged some cash.


We will benefit from the free SQL Server and DB support in Azure.

  • Step 1: Select SQL Database option. If you already have db created you might want to use it
  • Step 2: Hit the f*ucking Create a new database
  • Step 3: Give meaningful name for you database

  • Step 1: Create a new database - you have selected it already.
  • Step 2: Choose Target server. If you already have server created you might want to use it
  • Step 3: Once you choose create a new server be sure to fulfill the form correctly. Remember your Server admin login and Password fields. You will need them for your DB connection string

If you configured your server as needed the next step is just a peace of cake

  • Step 1: Choose Pricing tier
  • Step 2: Make sure you've selected the Free offer
  • Step 3: Click the f*cking Apply button

At the end your final move will be something like on the picture below. Wait few minutes until your service is created. You can access your app from your portal Dashboard


Craftsman menu


Required Tools 4 Course


External resources


Useful Things


Internal resources

Basic OOP recall

Database 1st with local db

Code1st with external db instance (part1)

Clone this wiki locally