Error Fix: The database YourDatabaseName is not accessible while connect SQL Azure database from SQL Server Management Studio

Error connecting SSMS to SQL Azure

We have already seen that how to connect SQL Azure database from SQL Server Management Studio (SSMS) installed in your computer (for details, click here). I have received one email in which, one of the reader was asking that he is getting error something like this:

The database YourDatabaseName is not accessible

He can able to connect SSMS to SQL Azure server and also access “Master” database too but he can’t access his own database he created from online SQL Azure portal.

See the screen capture of error :

IMAGE 1:

Well, You can connect to your own database from SSMS if it is SQL Server 2008 R2 or greater. Older SSMS will not be able to connect to your user database in SQL Azure.

Enjoy Microsoft Cloud!!!

Reference: Ritesh Shah

http://Extreme-Advice.com

http://www.sqlhub.com

Quick Learn

Note: Microsoft Books online is a default reference of all articles .