Introduction:

In this article we can see how to test the connectivity level of the database created using the Azure Management portal.

Overview:

Using SQL Azure we can create our own database server and the databases based on the requirement of our application created using the Azure management portal(Check article on how to Create New Server and Database). Once we created our new servers and databases we need to do a manual check of testing the connectivity using the credentials before we provide the credentials to the development team to use it for the front end application.

Normally in standard SQL server edition locally we can test the connectivity by giving the username and password valid for that database server and check if the connection is established correctly or not. Same way here we are going to do that using the Azure portal. Lets see on how to do this step by step

Steps:

Log in to the Azure portal using the below link. You can see the screen look similar to below

http://www.microsoft.com/windowsazure/

Login to the portal using your Microsoft Windows Live credentials with Azure credentials to the management portal and you will see the screen as shown in the screen below

Now we can see the Database Menu at the bottom left, Click on that will go to the Database Subscription window as shown in the screen below

Clicking on the subscription name will provide the complete details of the server created and the new database created as shown in the screen below

Now to test the connectivity of the server and the database, Select the particular database (LearnAzure) and we click on Test Connectivity button at the top of the menu tool bar as shown in the screen below

Clicking on Test Connectivity will open a popup as shown in the screen below

Now we need to provide the password which we created during configuration of the new database and click on Connect button we may or may not get a error window as shown in the screen below

This error message indicates that the IP is not added to the firewall which we need to provide in order to have a secure connection to the SQL Azure database. So to over come this error click copy the IP address from the error message and click on the close button.

Now we can see the Firewall Rules tab with the added IP address as shown in the screen below

Click on that button will drop down the list of IP address added as shown in the screen below. Here we need to Click on ADD button to add the new IP address to the firewall

After adding the IP address we can see the IP added to the list as shown in the screen below

Now Click on the Test connectivity button and give the valid password and click on Connect button to test the connectivity as shown in the screen below

We can see the result as Success at the bottom as shown in the screen below if the credentials are valid 🙂

Conclusion:

So in this article we have seen on how to test the connectivity of the databases created using the inbuilt option provided in the Azure management portal.