Connect to SQL Azure using SQL Server Management Studio 2008
SQL Azure is now in CTP and for those who have received an invitation to test it out, you might be wondering how you can manage your databases via SQL Server Management Studio…. Here’s a few steps to do it:
- Set up your SQL Azure server and Administrator Username via https://sql.azure.com/
- On the SQL Azure website under Firewall Settings ensure you check “Allow Microsoft Services access to this server” and add your IP address to the IP Address Range
- Open SQL Server Management Studio
- Close the “Connect to Server” dialogue and click “New Query”
- In the “Connect to Server” dialogue box type the server name provided via the SQL Azure website, e.g: <servername>.database.windows.net
- Select Authentication to SQL Server Authentication
- Your username is the Administrator Username you set up in this format: <username>@<servername>
- Password is obvious?
From here you can run as much T-SQL as you like :)