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:

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.

logon

Step 2:

Database

Select SQL database from the list and click on

New

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

Create

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”.

CustomDB

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.

SQLAdmin

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

Databases

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.

Dashboard

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.

Windows Azure Services

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

Select

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

Username – sqladmin
Passsword – Passw0rd!
credentials

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:

configuration

Next Recommended Readings