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.
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 to go to the Database Subscription window as shown in the screen below:
Clicking on the subscription name will show the complete details of the server created and the new database created as shown in the screen below:
Now we will create a new database for our learning purpose called 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:
Now click on the database server name listed at the right side menu and we will see the list of databases available on the server. Now select the database for which we need to get the connection string and we can see some information of the database as highlighted in the screen below.
On the highlighted items at the right side corner menu we can find an option Connection string with a small button on 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 strings popped up by the portal as listed below:
In the connection string shown in the following screen, if we can see the password then it is exposed for viewing and it's by default that 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.
Azure Web Apps for Developers