Archive

Posts Tagged ‘database’

Windows Azure: How to Create a SQL Azure Database

June 3, 2011 1 comment

In this article, I will show you how to create a new SQL Azure Database. I assume that you already have created a SQL Azure Server. If you have not created one, visit my previous post on How to create a SQL Azure Server.

  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. Click on the Create new SQL Azure Database located in the center of the page.


    Alternatively, if you’re at the Subscription Home, you can click on Create button at the ribbon at the top of the page.

    azure_mgmtPortal_ribbon_database_database

  4. Now in the pop-up wizard, enter your Database name, select the Edition, and the maximum size of the database. Click OK when you’re done.

    azure_mgmtPortal_nav_database_serverList_withDatabase

Now, you should be able to see your newly created SQL Azure Database under your SQL Azure Server.

Windows Azure: How to create a SQL Azure Server

June 3, 2011 1 comment

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.

azure_mgmtPortal_nav_database_serverList