Connecting to SQL Data Services (SDS) with SQL Server Management Studio (SSMS)

In order to connect to SQL Data Services, you should have an invitation for working with SQL Azure CTP (discussed in previous article working with SQL Data Services –SDS)

1. Start SSMS 2008. When it asks for a connection to the services, click on Cancel. If by mistake you try connecting using this window, you get following error

clip_image002

2. Click on New query and enter following details. We can only connect using SQL Server authentication as that is the only mode supported in SQL Azure.

clip_image004

3. Click on Options and enter the database name as follows

clip_image006

If you select <default> option or <browse Server> option from Select Database we get errors

clip_image008

clip_image010

You will get a warning as shown below:

clip_image012

Click OK and you are connected to SQL Azure.


No comments: