Sunday, March 25, 2012

Creating an SQL Azure Server

Log in to your Windows Azure Platform at Press the New Database Server on the ribbon to create a new SQL Azure server.

New Database Server button in Windows Azure Platform

In the Getting Started area, click on the Create a new SQL Azure Server tile.

Create a new SQL Azure Server tile in Windows Azure platform

You will be prompted to select a Subscription. Select your subscription (for example, 3-Month Free Trial) and press Next.

Subscription selection for new Azure database server

Select the desired region for your server, and press Next. In our case, this is South Central US.

Region selection for new Azure database server

You will now have to enter an administrator username and password. Windows Azure has stringent username and password requirements – you cannot use common usernames such as admin or sa, and your password must have a combination of letters and numbers, without any strings longer than three letters from the username.

Enter your preferred username and password, and press Next.

Administrator username and password for new Azure database server

The next screen will require you to make firewall rules to enable access to the servers. Check the box to “Allow other Windows Azure services to access this server”. Press Add, and create a new rule to allow your current IP address. Your IP will be displayed on the Add Rule screen. Name the rule, and add this rule to the list. Press Finish to create the server.

Firewall rules for SQL Azure database server

In the tree in the upper left corner, find and select the server you just created. From here, you can view the database information. In the Properties section on the right side, you can find the Fully Qualified DNS Name. You will need to use this name to connect to the database. You can also manage databases from this screen.

Server Information Screen in Windows Azure Platform

No comments:

You can find more about Code OnTime Generator, Data Aquarium Framework, and other great products here.

© 2010 Code OnTime LLC. Intelligent code generation software for ASP.NET. Visit us at