Floating FB popout byF5debug

SQL Azure – Getting Connection Strings Generated in Azure Portal

 

Introduction:

In this article we are going to see how to get the connection string for the newly created SQL Azure Database using the Management portal in SQL Azure.

Overview:

After we create a new server with a new database, in order to proceed further to use the SQL Azure database to our application for processing the data we need to have a connection string. Normally we write our connection strings based on the parameters like data source, user name, password etc and prepare a string which has the connection properties.

[more]

But with SQL Azure by default the connection string will be prepared and be provided ready for our development process. Let us see on how to get the connection string from the azure portal 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_image002

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_image004

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_image006

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_image008

Now we will create a new database for our learning purpose as LearnAzure(Check my existing article on how to create a database using Azure portal) and we can see the database listed as shown in the screen below

clip_image009

Now click on the database server name listed at the right side menu and we will see the list of database available on the server. clip_image010

Now select the database for which we need to get the connection string and we can see some information’s of the database as highlighted in the screen below.

clip_image011

On the highlighted items at the right side corner menu we can find an option Connection string with a small button to it. Clicking on that button will pop-up a window as shown in the screen below.

In the screen below we can see 3 different connection string popped up by the portal as listed below

  • ADO.Net
  • ODBC
  • PHP Code

As per our requirement we can copy the connection string and use it in our development process. If we can see the connection string we can find the complete server details with Username and password on to it as shown in the screen below

clip_image012

In the connection string shown in the below screen, if we can see the password is open to see and its by default they specify with mypassword. We need to copy the whole connection string to the development environment and change the password to the original authenticated one which we have given on registration.

clip_image013

Conclusion:

In this series of articles we have seen on how to get the connection string of the created Azure database using the Azure management portal and the different connection string created automatically by the azure 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

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