March 17, 2006 at 9:39 am
Hi all,
I have a problem in one of my production servsers. It's a clustered environment, running Win2K3, SQL 2K SP3.
I cannot see any of my databases from Enterprise Manager, "no items", same thing under Management. But when I connect via Query Analyzer, all my db's are there and I can select data from the db's. Has anyone come across anything like this? Is this an appearance issue with EM?
Please help.
Thank you
March 17, 2006 at 10:44 am
Did you register the SQL Server instance? (In EM, right click on SQL Server Groups).
If you did, try refreshing.
Lastly, what version of SQL Server are you using (SELECT ServerProperty(ProductVersion)).
-SQLBill
March 17, 2006 at 11:00 am
I deleted the registration, and re-registered it, still nothing.
Version = 8.00.760
March 17, 2006 at 6:40 pm
Have you checked to see if someone changed the code in the master stored procedure sp_MSdbuseraccess.
It is what displays the list of DBs
Try the following in Query Analyzer
use master;
GO
EXEC sp_MSdbuseraccess @mode = 'db'
If it does not return a list of DBs it is the problem, or at least I think it is.
If sp_MSdbuseraccess appears to be the problem, I would start with
http://support.microsoft.com/default.aspx/kb/889696
Tim S
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply