Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a Windows Azure database which I wish to add/remove tables to, and yesterday I witnessed a colleague do this online, on what looked like a web based SQL management studio, but I can't find it anywhere.

I can see a Manage button in the toolbar at the bottom of the page, but all this seems to do is refresh the page. How do I reach the web based management console I saw my colleague use yesterday?

I also tried to connect to the database using Visual Studio's server explorer, but when I try to add a table, I get this helpful error:

Error

share|improve this question
1  
How about asking your colleague? (Well, I see it's weekend just now.) –  dezso Feb 2 '13 at 15:45
add comment

2 Answers

up vote 2 down vote accepted

The Manage button is correct. It should bring up a page in a new window/tab that prompts for the user name and password to connect to the database. If that isn't working, there's something wrong with your web browser configuration (does it allow popups from the Azure site?).

Alternatively, the database server can be set up to allow external connections by managing the firewall rules. The interface makes it very easy to poke a hole just for your client computer. You can then connect to the database directly using Management Studio on your local machine. (Don't forget to delete the firewall rule when you're finished.)

share|improve this answer
    
It was a popup blocker! Thanks –  JMK Feb 5 '13 at 15:16
    
@JMK: You're welcome. –  Jon Seigel Feb 5 '13 at 15:27
add comment

This is the format of your managment portal.

Substitute the yoursqlservername (usually something like bhjjeliwwk :)

https://yoursqlservername.database.windows.net

It's the same as in your connection string.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.