Databases Reference
In-Depth Information
As previously discussed, the size of the database can be 1GB or 5GB for Web edition, or 10GB-150GB for
Business. If the
MAXSIZE
parameter isn't defined, the size of the database is set to 1 GB.
Configuring the Firewall
SQL Database implements a firewall on your behalf. That's a benefit that helps protect your database. Indeed, the
default firewall rule is that
no one
can connect to a newly created SQL Database server. You can use the management
portal to configure your firewall rules at any time and create databases even if no firewall rules are defined. Allowing
no connections by default is a good security practice, because it forces you to think through what IP addresses you
wish to allow in.
Follow these steps to add an IP address (or IP range) for a computer that needs access to the SQL Database
server:
1.
In the Windows Azure Management Portal, select the SQL Databases tab in the left
navigation bar.
2.
Select the Servers tab above the List Items section.
3.
Select the server name you want to add the firewall rule to.
4.
Select the Configure tab on the top of the List Items section.
5.
In the Allowed IP Addresses section, enter a rule name and the Start and End IP addresses
as shown in Figure
1-6
. Click Save.
Figure 1-6.
Firewall settings
6.
Additionally, if you have Windows Azure services that need access to your SQL Database
server, select Yes for the Windows Azure Services option in the in the Allowed Services
section.
