Creating Microsoft Azure SQL Database

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


The following are required to complete the demo:

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.

display connection string,

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 to allow this database access from any IP.

Windows Azure Services

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:


Up Next
    Ebook Download
    View all
    View all