Laurent Kempé

How to connect to SQL Azure

From Microsoft SQL Server Management Studio (tips from the SQL Azure — Getting Started forum, this post) :

Please be aware that SSMS is not supported with SQL Azure yet. However, you can use the following workaround for the time being:

1. Click Cancel in Connect to Server Dialog
2. Click New Query which will bring up the new connection dialog.
3. Enter your credentials. By default, you will connect to Master database. If you want to connect to specific database, click options and enter the database name. Please be aware that USE <database> is not supported.
4. Now click Connect and you will get an error "Unable to apply connection settings. The detailed error message is: ‘ANSI_NULLS’ is not a recognized SET option. "
5. Click Ok.

After this step, you should be connected to the desired database and you can start running queries.
Thanks,
Abi

Here are the information you need to enter into Microsoft SQL Server Management Studio. You will get those from

You will get this error message, just click OK

According to Stan Kitsis – MSFT (MSFT, Moderator) (link):

I'm not aware of a way to get around this message.  We are planning to enable support for SET ANSI_NULLS in the next service update so hopefully the experience will be better.
Stan

---

Program Manager, SQL Azure

I also tried to run aspnet_regsql.exe without any success, there are still lots of features which seems to be not supported at the moment.