Cant see my database in SQL server Management Studio

[AllendeL4S]

Hi Friends

I have a SQL database in HSPHERE. It works fine since I can connect from my web application with no issue.
I'm trying to connect remotely using SQL Server Management Studio and it connects to the server perfectly but it wont list my database.
It is weird since if I browse the databases at the moment of establishing the connection it lists it. Also, if I run a "select * from sysobjects" it will show all my tables and SP there...
The connection in the Object Explorer shows a white empty circle instead the regular green triangle.

Am I missing something here?

BTW How can I download the database to my PC?? I would like to do a backup but I wont be able till I can see the DB listed.

Thanks a lot

 

[akshay]

Please open a support ticket with mention database name and login details we will check it and get back to you.
For any further support, please email [email protected] including your VPS hostname each time. Also you can open a account at our VPS support system at http://helpdesk.jodovps.com/

 

[Stephen]

BTW you can't download the DB from Management Studio anyway, it will not allow that, you have to do it via the web GUI that we can give you the exact URL for via ticket. You can issue queries as you noted via the query engine without issue, this is due to some security limits on SQL 2005 with the way it works with the control panel.