Getting Started With SQL Azure series:
1. What is SQL Azure?
2. Creating First SQL Azure Database
3. Provisioning and Billing Model
4. SQL Azure Architecture
5. SQL Azure's security model
6. Migrating Databases to SQL Azure
7. Administration Tasks - I
8. Administration Tasks - II
9. Developing SQL Azure applications
10A. Getting started with SQL Azure reporting and SQL Azure Data SYNC
In this article, we will first get you a Windows Azure account, if
you don’t have one. Then, we will create a SQL Azure Database. And then,
we will try connecting to it through SQL Server Management Studio
running on our machine.
To create SQL Azure Databases, you will need a Windows Azure account.
So let us go ahead and sign up for a Windows Azure account. Just a
heads up before we do so, you will need a credit card to sign up for a
Windows Azure subscription.
In addition, you may ask, “Can I sign up for SQL Azure subscription
and not Windows Azure subscription?” Not exactly, SQL Azure is a part of
Windows Azure and so you could get yourself a Windows Azure account and
do not use other components. Since you pay for ONLY what you use - no extra charges are applicable. So yes, let us go ahead and get a Windows Azure subscription:
If you are just starting out, you can sign up for a Free Trial that is being offered by Microsoft.
Now go to: http://www.microsoft.com/windowsazure/free-trial/
Note that with a free trial, we will get a 1 GB web edition SQL Azure database, which I believe is all you need to get started!
Quiz: Can you create more than one “1 GB” web
edition SQL Azure database at a single point of time and still not get
charged for it during free trial? What do you think (you may use comment
section to continue our discussion). In next post, I will explain you
SQL Azure billing model and we will try understanding it in detail
there. For now, if you want a reference to think more about the
question, here it is Accounts and billing in SQL Azure.
Information about other plans can be found at http://www.microsoft.com/windowsazure/offers/
Now, just a quick steps of what you can expect when you try signing up for Free Trial.
- Click on Free Trial
- Login using a windows live id
- Enter Contact information
- Review the pricing and online subscription agreement
- Enter Billing information
- You will get a message like: "Your subscription is being
provisioned... The Windows Azure subscription you have just created is
being provisioned in our system. It can take up to 15 minutes to
complete the provisioning process.
Your order confirmation number is xxxxxxxxxx
In the mean time you can explore the resources below, and they will help
you onboard on Windows Azure faster."
- And you will be redirected to Azure management portal when your subscription is successfully provisioned!
If by any chance you are asked to verify your account via text
message - please do so. If you are not from a country that is listed,
then please contact support for manual verification. Also, please have a look at http://blogs.msdn.com/b/windowsazure/archive/2011/05/23/fraud-prevention-measure-for-new-windows-azure-platform-accounts.aspx for more information.
And Congrats! You have successfully signed up for a Windows Azure free trial!
Now, This is what an Azure Management Portal looks like:
This is a one-stop place to manage all your hosted services, storage
accounts, databases, etc. And I love the portal! It’s very easy to get
familiar with the portal. I am just going to ask you to become a kid and
explore this portal if you have not done so before! (Just make sure
that you do not create/deploy things that you may get charged for – be a
Now, when you are done with exploring, let’s create our very first SQL Azure Server!
There are two ways to do so from Home section in Azure Management Portal:
- You may click on “New database server” tab found in the top of the page
- You may also click on “Database” found in the left pane under Home section. On clicking it, you will see:
Now click on “create a new SQL Azure server” section found in the center pane:
Now, Select the subscription and click on next:
Now, Select the Region and click on next:
Now, choose Administrator login and password. Choose a secure password and secure login ID. It is equivalent to “sa” for SQL server and so you may have understood the importance of this login ID and password. BTW “sa” login id is not supported.
Once you are done, you will see:
Now, this is where you configure the SQL Azure firewall which is a special security mechanism in SQL Azure which blocks requests based on it’s IP address. Simple concept but it is crucial to protect our SQL Azure servers from unwanted access. So configure it cautiously! Click on “Add”
For now, I am just going to allow my computer to be able to connect to this server so I create a rule that starts and ends with my current IP address. click on “ok”:
Here, you will be able to see the list of firewall rules. You can update or delete any rule you may want to. Note that I want to allow windows Azure services to access this server so I just checked the box. Click on Finish to see newly created server:
just that you know, I have more than one subscription associated with my live id, you may see only one subscription under the “subscriptions” tab on the left side. And the name of the subscription that I created for this article is “Subscription-1”
And as you can see in the above image, your server properties can be found on the right side too. Now, let’s create a SQL Azure Database! To do so, click on “create” found on top pane:
Enter the name:
And click on “ok”:
Your very first SQL Azure database has been created!
Now, Fire up SSMS:
Note: SQL Server Management Studio from SQL Server 2008 R2 and SQL Server 2008 R2 Express should be used. previous versions of SSMS are not supported.
Now, Enter login credentials.
For now, we would not bother with “options”.
Click on connect and we are connected to our SQL Azure server!
In case, you are not able to connect to SQL Azure server, please have a look at http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-connectivity-troubleshooting-guide.aspx
Let’s create a table in MyFirstSQLAzureDatabase:
So yes! That is it.
In this article
1. We got you a Windows Azure account (to play with SQL Azure)!
2. We created our very first SQL Azure database (and table too!)
3. We connected to SQL Azure server Via SSMS
In next article, we will discuss about provisioning and billing model of SQL Azure. Stay tuned!
Update: Part 3