Skip to main content

How To sign up For SQL Azure Database – Step By Step

Today I got the SQL Azure October CTP invitation code. So I sign up for the SQL Azure and created my database server and 1 database. I am allowed to create 1 SQL server and 5 databases.

If you are interested in evaluating and want to receive the CTP invite then you can fill up the following form and Microsoft will send you invites soon. 

https://connect.microsoft.com/Survey/NominationSurvey.aspx?SurveyID=5719&ProgramID=2089&SiteID=547

 

What is SQL Azure

Microsoft SQL Azure Database is a cloud-based relational database service that is built on SQL Server technologies and runs in Microsoft data centers on hardware that is owned, hosted, and maintained by Microsoft.

More details: SQL Azure Overview

 

Step By Step Sign up Process

1. Open https://sql.azure.com

2. Sign in with a valid Windows LiveID

3. Enter your invitation code that you will receive in email

image

4. Read & accept the terms  of use

image

 

5. Create your SQL Azure Server. To create your server, enter the username & password that you would like to use for administrator. The SQL Azure server name will be automatically generated.

Password Requirements: Password must be at least 8 characters long, and contain at least one number, one letter, and one symbol. Password cannot contain any three consecutive characters in the username.

image

6. Once you meet the password requirements and click create server then you will see following screen.

You can see that your database server has been created and listed under My Project. In My Project you will see all the projects you have created or for which you have been designated as a Service Administrator by your Account Administrator.

image

7. Double click on the project name to open the project. You will see the following screen which will display your database server name, admin username, option to change password and a list of databases.

You can create new database by clicking the Create Database button.

image

8. Click on Create Database button. It will show a screen to enter the database name and select the size. Size options are 1 GB & 10 GB. 1 GB means you selecting Web Edition while 10 GB means you are selecting Business Edition. Compete pricing details available at http://www.microsoft.com/windowsazure/pricing/#sql

image

Select 1 GB and click at Create Button

9. The database will be created and listed in the database list.

image

10. You can select the database and click at the connection string to view the connection string. You can use this connection string to configure your application (e.g. web.config file).

image

Helpful Resources and Tips

SQL Azure Documentation:

http://msdn.microsoft.com/en-us/library/ee336279.aspx

SQL Azure Forum:

http://social.msdn.microsoft.com/forums/en-US/ssdsgetstarted/threads/

SQL Azure Blog:

http://blogs.msdn.com/ssds/

Quick Tip:  Using SQLCMD with SQL Azure

http://msdn.microsoft.com/en-us/library/ee336280.aspx




Comments

  1. Nice information. I was searching for the same. It helped me alot and saved my time. Thanks alot. , windows azure training in hyderabad

    ReplyDelete
  2. SQL and database are the real mean of data maintenance and are truly very secure. As it may provide us different kind of facilities and the best essays written should be like that consistency be the part of database so people may get accurate result about anything whenever they want. Not all have the access to database but only data administrator.

    ReplyDelete
  3. It is very arduous to mention once precisely have to be compelled to money your check. generally it's going to terribly troublesome to money if it's not official hours
    check cashing near me Philadelphia

    ReplyDelete

Post a Comment

Popular posts from this blog

SharePoint WebPart Error - Unable to add selected web part (s) – MOSS 2007

ISSUE: Recently I faced this issue that when I try to deploy my WebPart.  Unable to add selected web part(s).WebPartName: Cannon unregister UpdatePanel with ID ‘ctl00RTMPanel’ since it was not registerd with the ScripManager. This might occure if the UpdatePanel was removed from the control tree and later added again, which is not supported.
Parameter name: updatePanel.I faced this issue twice and both the time the issue was not what display here. This could be sure to any error in the WebPart. Following are list resolution from multiple instances.RESOLUTION: 1. Check the WebPartName.webpart file. Check whether you have a proper PublicKeyToken value. When I face the issue the value was PublicKeyToken=$PublicKeyToken$. If you have used WSP builder then in the Visual Studio you will find this file at \WebPartsProject\12\TEMPLATE\FEATURES\WebPartName\WebPartName.webpart. Sometime when you create a new WebPart using WSP builder then you do not get the correct value. The WebPartName.we…

How To Create Virtual Machine Using Existing vmdk file in VMWare Workstation

vmdk file is hard disk of the VMWare virtual machine. There are many scenarios where you may need to create a new virtual machine for an existing vmdk file. This is also an alternate Method to the “vmx is not a valid virtual machine configuration file – Could not open virtual machine” issue.Please refer to the previous post “Could not open virtual machine – vmx is not a valid virtual machine configuration file” for a full list of possible resolution. This post is to describe one of the solution in more details. How To Create a new virtual machine & attach the existing .vmdk file:1. Open VMware and select create a new virtual machine with custom (advanced) configuration option.2. Chose “I will install the operating system later”. and chose “I will install the operating system later”. 3. Select the operating system that matches the operating system in your existing .vldk file.4. Select a location of the new virtual machine5. Chose “Use an existing virtual disk”. This will allow yo…

My Grandparents – Grand Parents Day Essay Competition Winner

Vedic won the Grand Parents Day Essay Competition at HSCF New Age Sr. Group function. There were 27 participants in his category (Elementary School Category) and he won 1st price.Full list of winners are available at http://www.hindutempleorlando.org/new-age-group.

Video of Vedic reading his essay after winning:


My Grandparents – Grand Parents Day Essay Competition Winner from Laksha on Vimeo.

Below is the script of his Essay: My Grandparents I have three grandparents, my “dada ji, dadi ji and nani ji”. My grandparents live in India. Sometime I go to India and stay with them.

My dada ji is a homeopathic doctor. Whenever I get sick he gives me sweet medicine. I love my dada ji because my dada ji take me out for a walk and always play with me. And whenever we go for a walk my dada ji tells me stories.

My grand ma takes me to temple. She even played with me and made food for me.

My nani ji sing “Bhajans” everyday. She play with me and take me to the satsang.

I love my gr…