I was meddling with SQL Azure for a while now and was trying to connect from SQL Management Studio. Follow the steps below, which i used to establish a connection between SQL Azure and SQL Management Studio:
Note: You will have to have access to SQL Azure CTP. If not, navigate to http://lx.azure.microsoft.com/
-
Open up the SQL Management Studio 2008
-
Cancel the login dialog box that would pop up
-
Create a ‘New Query’
-
Now, select the Database engine
-
Enter the FQDN which you got for SQL Azure server. If you don’t find that, obtain one from the SQL Azure portal.
-
Enter the login name (<login_name>@servername) and also your password
-
Now, select Options
-
Enter the database name. This is the DB that you would have created. It may be the master or any other database that you have.
-
Click on connect
Viola!! You are now connected with SQL Azure from your SQL Management Studio 2008. I initially experienced some problems and came to know that it can be rectified, checking the following:
-
Check the database name, user name, password and Server name
-
Check the firewall settings. (Your firewall should allow 1433)
If you have got any query, please feel free to comment here! Would love to help you people! Rock On!