TechBubbles Microsoft Technology BLOG

Creating a database in SQL Azure

 

This post discusses about setting up a windows Azure and creating a SQL Azure database. There 3 main steps to create a main database

image

Step1: Visit the Windows Azure website and select the suitable offer. For testing and knowing the features there is a introductory offer which is free to use as long as you do not exceed the monthly usage hours. visit here for offer

image

The above offer provides a base level of compute hours, AppFabric and SQL Azure Database at no charge.

Step2: Visit the customer portal for contact information. It asks you to signup using the windows live account , after login you will see the below contact information screen.

image

click next and enter your credit card information, they would not charge for this usage, read the terms and conditions and say purchase. You will see the below order confirmation offer and ask you to activate the offer.

image

After clicking on activation link then it asks you to update the service administration account information and say ok then you will receive an email about activation information and ready to use the SQL Azure.

image

Step3: Visit the developer portal to create a administrative account and manage settings and create first database. The developer portal looks as shown below

image 

Click the database from the left pane and click  create from the ribbon bar

image

Select your region and click next from the above window then it asks you to enter the SQL Server administrative login details

image

It will then ask you to enter the IP address of the machine that you wish to access this database

image

Now you are single click away from creating a database on the server. Select the server from the left pane and say create database button from the ribbon as shown below

image

Enter the database name that you want to create and save the information. Introductory offers allows you to create a database of size 1 GB.

image

Now you have a create a database on cloud and it looks as below. Test the connection to the database by clicking on the Test Connection and entering the username and password details.

image

Share this post :

About the author

Kalyan Bandarupalli

My name is kalyan, I am a software architect and builds the applications using Microsoft .NET technologies. Here I am trying to share what I feel and what I think with whoever comes along wandering to Internet home of mine.I hope that this page and its contents will speak for me and that is the reason I am not going to say anything specially about my self here.

Add Comment

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud