Creating and Accessing an SQL Azure Database

SQL Azure is Microsoft’s offering for a cloud database service. It supports T-SQL and it also allows synchronization between on-premise SQL databases. Since it is a cloud service, don’t have to worry about your own server, which may be of great advantage to small organizations. Other pros include:

  • The ability to scale up and down based on your organization’s usage
  • No hardware purchase
  • Azure security
  • Availability 24/7
  • No administrative duties on your side

Below are the steps in creating an SQL Azure Database:


  • Azure Subscription
  • Enough Credits


  • Login to the Azure Portal
  • Click SQL Databases on the left panel


SQL DB.png

  • Click Create
  • You should now have it in the list of SQL Databases in your subscription

SQL DB.png


For us to access the database, we need to do some configurations

  • Add client IP in the Firewall Settings
    • Click your newly created SQL Server
    • Click Set Server Firewall

SQL DB.png

  • Click Add client IP
  • Make sure theh Allow access to Azure services is turned On

SQL DB.png


  • Click Save

Accessing the Database

Now that we have created and configured the Azure SQL, time to access it.

Make sure you have a Microsoft SQL Server Management Studio (SSMS).

  • Open SSMS
  • Enter the following details
    • Server Type: Database Engine
    • Server Name:
      • The name of the server you used in creating the Azure SQL
    • Authentication: SQL Server Authentication
    • Login: Your server login
    • Password: Your server password


  • After clicking Connect, you will be asked for your Microsoft Azure credentials


  • Enter your credentials and you should be good to go.


After following the steps, you should now have a working Azure SQL database.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s