Windows Azure: How to create a SQL Azure Server

In this article, I will show you how to create a new SQL Azure Server in Windows Azure platform from the management portal.

1. Login to the Windows Azure Management Portal using your Live ID at http://windows.azure.com
2. Once you’re logged in, click the Database button at the lower left of the page.
3. If you have created a SQL Azure server, you can skip this step. Otherwise, click on Create a New SQL Server which is located at the center of the page.
4. A wizard will pop up. Select your subscription.
5. Select the region where your SQL Azure Server will be created.
6. Enter the Administrator username & password.
7. Add any Firewall rules. Check “Allow other Windows Azure services to access this server” to allow your Windows Azure app to access this database. Then click Finish.

Once you’re done, you can now see your SQL Azure Server at the panel at the left of your page. A default master database will also be created like any other Microsoft SQL Server.