How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ?

Leave a comment (0) Go to comments

YES, we can create our own SQL Server and database on the cloud using SQL Server AZURE that too FREELY !!!

Currently Microsoft is offering a Introductory offer, where following services / components are freely available to us. We can use this for production use too. I decided to use this space for Posting a series of Learning posts on SQL Server Cloud Computing

Following services are Included in this introductory offer

  • Windows Azure
    • 25 hours of a small compute instance
    • 500 MB of storage
    • 10,000 storage transactions
  • SQL Azure
    • 1GB Web Edition database (available for first 3 months only)
  • Windows Azure platform AppFabric
    • 100,000 Access Control transactions
    • 2 Service Bus connections
  • Data Transfers (per region)
    • 500 MB in
    • 500 MB out

Note : This introductory special will end on March 31, 2011. Sign UP TODAY ONLY !!!

What the STEPS Required to create a SQL Server Cloud Database on SQL AZURE ?

  1. Sign up for Windows live ID, if you do not have any one
  2. Sign up for Windows Azure Online Services.
  3. Login to Windows Azure Project
  4. Activate your Subscription
  5. LOGIN to SQL AZURE
  6. Create a Server
  7. Set up Firewall configuration
  8. Create a Database
  9. Connect directly from SSMS 2008 R2 .

Lets’ take  this ONE by ONE with Screen Shots.


  1. Go to http://www.microsoft.com/en-us/sqlazure/default.aspx
  2. CLICK on FREE TRIAL, as shown in picture

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

  • CLICK on BUY NOW, which is free product

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

  • Once you Click On BUY Button, you will get a Windows, live screen login with your WINDOWS Live ID and fill up the entire form and click Finish  Finally. This will ask for Credit Card Information too.

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

  • Once your account is setup, you will get the message with your subscription number, make a note of it and CLICK FINISH, after that, you will get a screen like this

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

Once this is finished, you will be asked for activate your subscription and straight forwardly redirected to the following welcome, summary screen

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

Otherwise, you can log into AZURE again. Go ahead and click on the link under SQL Azure. The web link for this is
http://sql.azure.com as shown

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

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.

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

Check the Status column to verify if your subscription is Enabled or not. If this is Enabled,

  • Click on Project NAME, in my case, this "DBATAG"

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

Click I Accept.

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

Then, you can create your logical server. Choose nearest location to you to avoid network bandwidth costs and achieve better performance and ACCEPT TEMS OF USE. Next step would be creating a new Virtual Database Server.

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.

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

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.

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

SQL Azure Firewall settings

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

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.

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow 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. Next click on Create to setup the database. USE Minimum setting to avoid charges.

Here is a screen demo from these steps.

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

Once, The Database is created, it will shown the database list and will also show you current occupied size

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

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, we get a dialog box with the connection string. I have included part of it here:

Server=tcp:******.database.windows.net;Database=SampleAZUREDB;User ID=DBATAG@****;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.

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)

Now Lets connect to this newly created SQL AZURE Server using SSMS. In the Connection String Specify Server NAME and USER NAME, which you received in connective string, for example

Server=tcp:******.database.windows.net

LOGIN=DBATAG@****

Password=yourPassword;

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

Once you supplied the Server NAME, LOGIN NAME and Password, you will be able to connect to SQL AZURE Server and will able to see the Sample database, which we created online.

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? WINDOWS AZURE STEPS Required to create a SQL Server Cloud Database on SQL AZURE SQL Azure How to SETUP SQL Azure Firewall settings How to make Connection String for SQL AZURE Server databaseHow to Connect to SQL AZURE Server and Database from the Locally Installed SQL Server Management Studio(SSMS)How to Create Table in SQL AZURE How to Create SQL Azure Database Server How to Create SQL Azure database Allow Microsoft Services

Once, we are connected, we can create database objects as required.

EOF - How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.