Tuesday, January 24, 2012

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. azure_mgmtPortal_content_database_getStarted
  4. A wizard will pop up. Select your subscription. azure_mgmtPortal_content_database_createServer
  5. Select the region where your SQL Azure Server will be created. azure_mgmtPortal_content_database_createServer_selectLocation
  6. Enter the Administrator username & password. azure_mgmtPortal_content_database_createServer_setAdminAccess
  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. azure_mgmtPortal_content_database_createServer_setFirewall
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.

No comments:

Post a Comment