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 .

Author: Riteshshah

Ritesh Shah is a database professional with having 16+ years of experience in various domain of IT field. He is a author of many technical articles on Microsoft Technology and authored a book of SQL Server 2012 Performance Tuning cookbook. He loves work with different Microsoft Products.