You will need to create a Windows Azure account to utilize the Azure
services. You can click here
to find the latest offers from Microsoft. There is usually a free 30 trial introductory
offer so you can try before you buy.
Once you've created a Windows Azure account you need to go to http://windows.azure.com to log into the
Windows Azure Management Portal.
The management portal is where you can create a new site, called a
hosted service, or create a new database. We'll first create a database and
then create a web site with Visual Studio 2010 to display data from a table in
To create a new database click on the "New Database Server"
icon at the top of the Management Portal.
On the left side you will see "Subscriptions". Click on the
subscription name that you created when you created your Windows Azure
account. For this sample I'm using the "Windows Azure Pass"
subscription. When you click on it, the buttons on the top toolbar should
Click the Create button in the Server section. This will bring up the "Create
Select the region where you want your database deployed and click the
Create an administrator user name and password and click the Next
The last page allows you to enable specific IP addresses that can access
this server. You should add your IP address by clicking the Add button. When
you click the Add button another page will display and tell you your current IP
address. Give this rule a name and then enter a start and end range. In this
example I'm using the same address for both.
the OK button and then click the Finish button. You'll be brought back to the
Management portal and the new server will be added to the subscription. In
this example the new server name is "its88ze5xt".
on the new server that you just created to highlight the row. The
"Create" button on the Database toolbar should become enabled. Click
the "Create" button.
window will pop up and ask you to give the database a name, pick the edition,
and a maximum size.
SampleDB for the name and select Web for the edition. Leave the maximum size
at 1GB. Now click the OK button.
database will be created and will appear under the subscription tree in the
left hand pane.
on the Database in the left hand pane and the "Manage" button should
become enabled on the Database toolbar. Click this button to create a table in
Database Manager will open in a new window and you will need to log in using
the same user name and password that you created when you created the server.
you entered the correct credentials click the Connect button.
may get an error when you click the Connect button. If you click on the error
details you'll see that the error is caused because another IP address needs to
be entered in the firewall rule. The details of the error tell you which IP
address to add. Copy this address and click back to the Management Portal.
on your server name under the Subscription node in the left hand pane.
the Firewall Rules button.
the Add button.
another name and then add the IP address that you copied down in step 18. Now
click the OK button.
back the Database manager window and try to connect again. You should now be
able to log into the Database manager.
is where you can create tables, stored procedures, views, and run queries.
Click on the "New Table" button in the toolbar.
Database Manager will create a table template with 3 fields. Change the table
name to "Person".
the ID field so it is an Identity field.
Column1's name to "FirstName". To change a column name double click
on the name and the cursor should appear in the cell. You can then delete the
old and enter the new.
Column2's name to "LastName".
both fields to Required.
the "+ Column" button to add a new column. Change the name of the
new column to "Email" and check the "Is Required" check
the Save button on the toolbar to save the table. The table should be
created. Click on the ">" button next to the word Tables (1) on
the side menu. You should see the dbo.Person node.
on the "dbo.Person" node and then click the "Data" button
on the toolbar.
brings up a page that allows you to add records to the table.
the "+ Row" button to add a row to the grid.
click on a cell to enter a first name, last name, and email. Add a few records
because this is what will be displayed in the application we will build.
the save button to commit your changes.
Now you can log out of the Database Manager and we will
build an ASP.NET web site to pull the data from this table and display it in a