How to Create a Database in Azure
Developing applications to make use of databases hosted in the cloud has many advantages. Just note that some concepts and tasks differ from those used with a local database. Although SQL Azure is fundamentally the same as SQL Server, creating databases with SQL Azure follows a different process than that used for a local SQL Server installation. The Windows Azure Developer Portal provides the tools for creating SQL Azure servers, databases and login accounts.
Other People Are Reading
Instructions
-
-
1
Purchase an SQL Azure offer or sign up for a free trial offer if you do not already have an SQL Azure account.
-
2
Sign into the Windows Azure Developer Portal with the Windows Live ID used to sign up for SQL Azure.
-
-
3
Click on the subscription in the left navigation pane.
-
4
Click the "Create" button on the "Server" ribbon to create a new server.
-
5
Select a geographic region where the SQL Azure server will be hosted, then click "Next."
-
6
Enter a new server administrator login name and password, then click "Next."
-
7
Check the checkbox to "Allow other Windows Azure services to access this server."
-
8
Click the "Add" button to add a firewall rule to restrict IP addresses that can access the new server. Click "Finish."
-
9
Click the subscription in the left navigation pane, then click the name of the new server.
-
10
Click the "Create" button on the "Database" ribbon.
-
11
Type a database name and choose an edition. Choose a maximum size for the database in the "Create Database" window, then click "OK." The new database will be created.
-
1
Tips & Warnings
Be sure to secure your database with login accounts and firewall rules.
