Creating Microsoft Azure SQL Database

Introduction: This article will guide you in the basics of how to create a Microsoft Azure SQL Database

Prerequisites

The following are required to complete the demo:

• Visual Studio Express 2013 or higher for Web.
  
• Microsoft Azure Tools for Microsoft Visual Studio 2.2.
  
• SQL Server Management Studio 2012 Express Edition or higher.
  
• Access to a SQL Database account with a created Server.
  
• SQL Database Firewall enabled for the machine, running this lab.
  
• Microsoft Azure subscription.
  
• Azure SDK for .NET - 2.4.
  

Follow the steps, given below:

Step 1: Open the Website of Azure Management portal and login using your Micrososft account (Hotmail, Outlook or live) you used in the previous steps.



Step 2:



Select SQL database from the list and click on



Now from the bottom left, select Data Services -> SQL Database -> Custom Create, as shown below:



Step 3: Specify the database name “CustomDB”. Select the service tier as “Basic”. Select the Collation as “SQL_Latin1_General_CP1_CI_AS” and from the Server, select “New SQL Database Server”.



Step 4: Specify the database login details.

Login name as “SQLAdmin”.

Password as “Passw0rd!” and make sure the check box “Allow Windows Azure Service to Access the Server” is selected.

Note: Allow Windows Azure Service to Access the Server, which allows you to connect to this database, using the Management portal for SQL database, Excel in Office 365 or Azure SQL Reporting.



Step 5: Once created, CustomerDB will be displayed under SQL databases. Select the database and it will take you to quick start Window.



Step 6: Quick start Window will display the connection string, which will be used later to connect to the database by the client Applications.



Step 7: Select SQL database. Select the database “CustomerDB” and click “Dashboard”.

Under Dashboard, select “Manage Allowed IP Addresses”.

This option will allow your local machine live IP, as the allowed IP to connect to the database.



Step 8: This option will connect to the Server, which is hosting SQL database. You can allow IPs, which you want to connect to this database.

Make sure “Windows Azure Services” are selected under Allowed Services.

Note: You can also add 0.0.0.0 to allow this database access from any IP.



Step 9: Select in the same screen and always allow on the pop-up screen.



Step 10: Login to SQL database, using the following credentials:

Username – sqladmin
Passsword – Passw0rd!


Step 11: Once you successfully log in, it allows the users to create the database table to insert the data.

Verify your configuration from the screenshot, given below: