Floating FB popout byF5debug

SQL Azure – Testing Database connectivity using Azure Portal

 

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.

[more]

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/

clip_image001

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

clip_image003

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

clip_image004

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

clip_image005

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

clip_image006

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

clip_image007

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

clip_image008

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

clip_image009

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

clip_image010

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

clip_image011

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

clip_image012

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

clip_image013

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.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Pingbacks and trackbacks (1)+

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter