Azure: Deploying ASP.NET Web App

Create SQL DB on Windows Azure

1.
Login into Azure portal.

2. Select NEW button at bottom left.

web app

3. Click COMPUTE, WEB APP, then Custom Create.

form gallery

4. Enter the specific URL ******.azurewebsites.NET.

5. Choose the location.

6. Select create database.

  • newFreeSql
  • newSql
  • newMySql
Note: If you are deploying ASP.NET, the preferred approach is to choose SQL database rather than MySQL.

Create web app

7. Next.

8. Select "Create a new SQL database".

9. Set credentials for server login and password.

specify data setting

10. Done

SQL DAtabase

Publishing

1. Right click on the project in solution explorer.

2. Click Publish.

click on publist

3. Setup profile.




4. Get connection string.

5. Click on valid test.

6. In settings, select DB, of which you have to upload on azure web app.

7. Preview DB

8. Click on publish and that's it.

Note: If during publishing, there is an error of firewall then open azure portal and select "setup firewall on azure" and select yes to continue.