CODEWITHSUNDEEP
sql-serverdatabase-connectionazure-sql-database
Tal Yaari
Tal Yaari

Reputation: 461

SQL Azure "The database XXX is not accessible"

I just created a user database using the SQL Azure portal.

I can manage my database with the portal, but I don't like it. It's not too Convenient so I connected with my administrative user to my instance with the Management Studio. When I try to change the database from "master" to my user database i get the following error:

SQL Azure "The database XXX is not accessible"

How can I overcome this problem ?

Thank you, Tal

Upvotes: 4

Views: 3568

Answers (2)

paras_doshi
paras_doshi

Reputation: 997

Guidelines for connecting to SQL Azure database: http://msdn.microsoft.com/en-us/library/ee336282.aspx

Upvotes: 0

Elian
Elian

Reputation: 323

Check that you well use Management Studio 2008R2 Do not forget to specify the db you want to manage in the Connection Options tab.

More info with screenshots on http://debugmode.net/2010/12/13/connecting-from-sql-server-2008-management-studio-to-sql-azure/

Upvotes: 6

Related Questions