Link to home
Start Free TrialLog in
Avatar of pete-mcpetey
pete-mcpeteyFlag for United States of America

asked on

Object Explorer does not display database

I have a database with GoDaddy. They inform me that they recently disabled the “view server state” permissions on MSSQL. So I can't view the database in Object Explorer in Sql Server Management Studio.

Is there any way to let it list the one database in Object Explorer? I don't have permissions to view all databases on the shared server. And I don't have database owner privileges.
Avatar of sammySeltzer
sammySeltzer
Flag of United States of America image

If you have sql server username/password, then you can log in using sql server authentication mode with SQL Server Web Data Admin tool. See this link below:

http://www.microsoft.com/downloads/en/details.aspx?familyid=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en
Avatar of pete-mcpetey

ASKER

That didn't work. I'm on windows xp and can't install IIS .
ASKER CERTIFIED SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
so VIEW DEFINITION will work, even if I don't have VIEW ANY DATABASE permissions?
Cool. I sent it for their review. It might take a while since it needs to go through their engineers and quality teams prior to deployment.
Thank you. This appeared to be the correct solution and makes perfect sense.