Wednesday, September 15, 2010

Invalid object name ‘sys.configurations’ while connecting to SQL Azure database via Microsoft SQL Server Management Studio

Just created a database in SQL Azure using Web UI – and promptly tried to connect using SSMS.

Failure:

image

Message:

Cannot connect to <servername>
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Invalid object name 'sys.configurations'. (Microsoft SQL Server, Error: 208)

The workaround is:

  1. cancel the first connect dialog box showed on start of SSMS
    image
  2. start with empty SSMS UI
    image
  3. Open “New Query…” –> the “Connect to server” dialog appears immediately:
    image
  4. Enter the connection data and press “Connect” – it should work now:
    image
  5. …enjoy!

More about this trick here (thanks to Stan Kitsis).


UPD: SSMS 2008 R2 worked as expected

3 comments:

Anonymous said...

Mike,

Try SQL Server Management Studio 2008 R2, it will connect without your trick. BTW: Free download with the Express edition.

-Wayne

winmike said...

Yes, Wayne - see UPD just @ end of posting.

Anonymous said...

Very good solution