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:
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.
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.
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 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.
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.
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.
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.
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.
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
I am glad you liked it, we will be posting more topics as we go Live soon with the website.
This is a fascinating post. Looking forward to reading more of your writing.
Bertrand Russell~ Guy requirements for his happiness not only the enjoyment of this or that but hope and enterprise and alter.
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.
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!
I know, how it is necessary to act, write in personal
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.
Really Gr8 ! Thanks For sharing..
very good article thanks for the info
Awesome, that’s exactly what I was scanning for! You just spared me alot of searching around
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.
Bookmarked – will come back within next week to evaluate rest posts.
Pingback: Alexander1
Pingback: Alexander7
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! .
sqlazuretutorials.com is bookmarked for future reference!
betathome
My cousin recommended this blog and she was totally right keep up the fantastic work!
sqlazuretutorials.com is awsome, bookmarked
Dog obedience training