Just created a database in SQL Azure using Web UI – and promptly tried to connect using SSMS.
Failure:
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:
- cancel the first connect dialog box showed on start of SSMS
- start with empty SSMS UI
- Open “New Query…” –> the “Connect to server” dialog appears immediately:
- Enter the connection data and press “Connect” – it should work now:
- …enjoy!
More about this trick here (thanks to Stan Kitsis).
3 comments:
Mike,
Try SQL Server Management Studio 2008 R2, it will connect without your trick. BTW: Free download with the Express edition.
-Wayne
Yes, Wayne - see UPD just @ end of posting.
Very good solution
Post a Comment