SQL Azure Object Browser Support in SQL Server 2008

If you are playing with the Azure training kit (November update) and you come across the lab about setting up SQL Azure, then you need to notice one thing:

the lab shows you how to connect to the cloud database using SQL Server 2008 R2 and thus you will get the Object Browser support.

However, the object browser is not supported in SQL Server 2008 pre-R2. So if you follow the steps without having R2 you will end up with an error message saying:
“Invalid Object name sys.configurations”.
The reason is that the Management Studio cannot load the Object Browser from SQL Azure simply because it is not supported yet (again for pre-2008 R2 releases).

So the only way to connect to your SQL Azure database is through the “New Query” link in the Management Studio. This will give you full connectivity but without the Object Browser, so you will have to rely on your DDL skills to manage your db objects.

Advertisements

One thought on “SQL Azure Object Browser Support in SQL Server 2008

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s