Database Reference
In-Depth Information
Figure 1-8.
Firewall error
Note
When you're creating a firewall rule, you may need to wait a few minutes for the rule to take effect.
You can also view and edit firewall settings directly using T-SQL by connecting to the master
database with the administrator account and using the following objects:
•
sys.firewall_rules
•
sp_set_firewall_rule
•
sp_delete_firewall_rule
Now that you've configured your SQL Azure database, the fun can begin!
Connecting with SQL Server Management Studio
Follow these steps to connect to your SQL Azure database using SQL Server Management Studio:
1.
You need to obtain the fully qualified server name of the SQL Azure database.
Figure 1-9 shows the server information on the SQL Azure portal. The fully
qualified server name is located above the Reset Password button.
Note
This example uses SQL Server 2008 SP1 Management Studio. Although you can connect to and manage
SQL Azure using this release, additional features are available using the SQL Server 2008 R2 release, such as the
ability to view database objects using the Object Browser.
2.
Start SQL Server Management Studio. Click the Cancel button in the Login
screen.
