Post reply

Enterprise Manager

  • March 17, 2006 at 9:39 am

    #189730

    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

    #627409

    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

    #627416

    I deleted the registration, and re-registered it, still nothing.

    Version = 8.00.760

  • March 17, 2006 at 6:40 pm

    #627463

    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