Connecting to SQL Azure

Question

How do I connect using MSSMS (Microft SQL Server Management Studio)?

Answer 1

Zack Skyles describes this in a blog post

You must cancel the first connection box when opening MSSMS, select New Query and then add your server and credentials and select your database under Options

Update: Using MSSQL Management Studio 2008 R2 (currently as CTP) it works fine without the tweak above.

Answer 2

See these links

Considerations for Connecting to SQL Azure

Connecting to SQL Azure from SQL Server Management Studio

Bye.

Answer 3

The problem is that you only have access to one database at a time - there is no cross-database stuff. That stops Object Explorer working, and also means that when you connect, you have to choose the Options, to set the name of the database you want to connect to.

Once you're in, you can query sys.objects (and more), to be able to navigate as you need.

But it's not your standard SSMS experience, since you don't have the Object Explorer.

Rob