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:

Pre-requisites:

  • Azure Subscription
  • Enough Credits

Create:

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

azure-sql-button

SQL DB.png

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

SQL DB.png

Configure:

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
      • servername.database.windows.net
    • Authentication: SQL Server Authentication
    • Login: Your server login
    • Password: Your server password

sql-db

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

terminal

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

 

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s