One of my SQLServer2000 host has database around 5000 databases. When i register this SQL host in Enterprise Manager MMC using an account with System Administrator server role (like sa), I can list all databases in the host. However, it take long time.
The problem is when i register this SQL host in EM MMC using account with non-System Administrator server role, I can't list any databases and EM console not response (hang). I already have many tries to wait for 1 - 2 hours but EM still hang. The non-SA account I use have access to all databases in the host as db_reader and db_writer. I require non-SA account to work on EM console for security reason.
Please give me some advise.