How do I setup SQL Azure Server and Database

How do I setup SQL Azure Server and Database

The first thing you need to do is setup a Windows Live account and then sign up for Windows Azure Online Services. We discuss this in this post so go ahead and check it out.

Windows Azure Portal

Once your account is setup you will need to log into the Windows Azure Portal. Here is the web address:

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

We have included a screen capture of this down below:

Windows Azure Portal

Go ahead and click on the link under SQL Azure. The web link for this is
http://sql.azure.com.

In our case sence we have already created a Windows Live account, it forwards us to that address. After activating your subscription, you can create your database server at the SQL Azure Developer Portal. Here is the actual link also.

https://sql.azure.com/ProjectViewer.aspx

Windows Azure Project

Once you sign in the Windows Azure Portal, the default project will be listed. By default, the subscription name will be used to name your project. In our case here is the screen shot for our project.

Windows Azure Projects

Check the Status column to verify if your subscription is Enabled or not. Click I Accept. Then, you can create your logical server. Choose the location that is closest to you to avoid extra bandwidth costs and achieve better performance.

Create SQL Azure Database Server

Next we are going to create the SQL Azure database server. Enter Administrator Username and Password, click Create Server. Here is the information from our SQL Azure server.

SQL Azure Database Server

This step goes ahead and create the Sql Azure server and a Master system database under it. Now you should be able to see SQL Azure Server administration page. We have included one for your review.

Sql Asure server administration

SQL Azure Firewall settings

Before we create a new database in SQL Azure we are going to configure the Firewall settings. This will allow connections from the Internet within a certain range of IP addresses. Click on Firewall settings and then select Add Rule.

This will open up a new dialog box with information on your home IP address. Go ahead and copy the IP address to the IP range text boxes. Click Submit next. Here is a monitor display from our Server Configuration.

sql azure add firewall

Allow Microsoft Services

In order to allow Microsoft Services and other applications to access your SQL Azure, you also need to check the box labeled Allow Microsoft Services. Here is the step in action.

Sql Azure Microsoft Services

Create SQL Azure database

Now we are ready to create a SQL Azure database using the SQL Development portal. Click on Databases tab and select Create database. Enter a name for the database, select an edition and max size. Next click on Create to setup the database.

Here is a screen demo from these steps.

Create Database Sql Azure

After the database is successfully created, you have a few operations that you can perform from the SQL Azure Portal. Here is the explanation on each of these:

Connection Strings:

This is helpful when you need to share the information for development purpose. When we clicked on it, I got a dialog box with the connection string. I have included part of it here:

Server=tcp:******.database.windows.net;Database=TestDatabase;User ID=kash****@****;Password=myPassword;Trusted_Connection=False;Encrypt=True;

Test Connectivity in SQL Azure

In order to make sure that all the settings are correct, go ahead and try to connect using the administration credentials from before. Here is a screen capture of this step.

SQL Azure connectivity

Drop Database in Azure SQL

Finally when you are all done with the SQL Azure database, you can go ahead and delete the database. You can click on Drop database. The step is shown right below.

Azure sql drop database

This entry was posted in Installation and tagged , , , . Bookmark the permalink.

19 Responses to How do I setup SQL Azure Server and Database

  1. bet365 says:

    hello!This was a really fabulous post!
    I come from milan, I was fortunate to approach your Topics in baidu
    Also I get a lot in your subject really thank your very much i will come daily

  2. Reba Skweres says:

    This is a fascinating post. Looking forward to reading more of your writing.

  3. Drew Hibl says:

    Bertrand Russell~ Guy requirements for his happiness not only the enjoyment of this or that but hope and enterprise and alter.

  4. CNA Training says:

    CNA Training
    You made various fine points there. I did a search on the subject matter and found a good number of folks will have the same opinion with your blog.

  5. Mikaela Wair says:

    Wonderful blog! I truly love how it? s easy on my eyes as well as the data are well written. I am wondering how I can be notified whenever a new post has been made. I have subscribed to your rss feed which need to do the trick! Have a nice day!

  6. ghd says:

    I know, how it is necessary to act, write in personal

  7. Hello there, I found your website via Google while searching for a related topic, your web site came up, it looks good. I’ve bookmarked it in my google bookmarks.

  8. The Dilemma says:

    Really Gr8 ! Thanks For sharing..

  9. carpets says:

    very good article thanks for the info

  10. Awesome, that’s exactly what I was scanning for! You just spared me alot of searching around

  11. I dont know what to say. This web site is amazing. Thats not truly a actually substantial statement, but its all I could come up with soon after reading this. You know a great deal about this subject. Much making sure that you produced me wish to understand additional about it. Your web site is my stepping stone, my buddy. Many thanks for that heads up on this theme.

  12. akcesoria says:

    Bookmarked – will come back within next week to evaluate rest posts.

  13. Pingback: Alexander1

  14. Pingback: Alexander7

  15. I like Your Article about How do I setup SQL Azure Server and Database | SQL Azure Tutorials – Blog Perfect just what I was searching for! .

  16. sqlazuretutorials.com is bookmarked for future reference!
    betathome

  17. My cousin recommended this blog and she was totally right keep up the fantastic work!

  18. dogtraining says:

    sqlazuretutorials.com is awsome, bookmarked
    Dog obedience training