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

TIME – 25 Best Blogs of 2009

Every year Time makes a list of best blogs in the world. They chose 25 blogs from millions of blogs in the world, spanning politics, housekeeping, astronomy and everything in between. Below if a direct link to the TIME website for the list. I also copied it to easy comparison of last year best with this year best blogs.   25 Best Blogs of 2009     25 Best Blogs 2008   25 Best Blogs of 2009 Talking Points Memo The Huffington Post Lifehacker Metafilter The Daily Dish by Andrew Sullivan Freakonomics BoingBoing Got2BeGreen Zen Habits The Conscience of a Liberal: Paul Krugman Crooks and Liars Generación Y Mashable Slashfood Official Google Blog synthesis bleat /Film Seth Godin's Blog Deadspin: Spor

Howto Run Your HTML Static Website Locally In IIS On Windows PC

WHAT & WHY: As a developer many time you may wish if you could run your static HTML website locally on your computer (Windows 7, Windows Vista, Windows XP, Windows 2008). Although with Static website, you could easily download and double click the index.html or home.html file to open and run other pages. But this will not give you the real world senario. For example you will not able to use a path like /images/home-page-banner.jpg. You will have to use a relative paths like ../images/home-page-banner.jpg. Following are very easy steps to do so. These steps are for Static HTML website. I will also post steps for more advance websites that uses ASP, ASP.NET, Dotnetnuke etc and uses database server.   WHAT YOU NEED: 1. IIS Server installed on your local machine 2. FTP username, password to download files form your FTP server 3. Administrative rights on local machine. Many task will display messages requesting Administrative privilege to run the task.    STEPS: 1.