Azure: Deploying ASP.NET Web App

Create SQL DB on Windows Azure

1. Login into Azure portal.

2. Select NEW button at bottom left.



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



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.



7. Next.

8. Select "Create a new SQL database".

9. Set credentials for server login and password.

10. Done



Publishing

1. Right click on the project in solution explorer.

2. Click Publish.

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.