Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dzach
Starting Member
38 Posts |
 Posted - 2008-06-09 : 15:40:46
|
| Received an email from a user who said they couldn't see any of the (many) databases from Enterprise Manager. I logged into my Enterprise Manager and sure enough, I couldn't see any databases either, and as it turns out, no one can. Yes, I've tried re-registering them, but they still don't appear.However, from Query Analyzer, the databases appear in the dropdown list and I can run queries against them without errors. I've also checked the event log on the server and there are no obvious SQL-related errors.Any ideas what could be causing this and how to fix?Thanks!Dale |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-06-09 : 17:56:10
|
| To me, it sounds like a network issue. Does EM still work on the server locally? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-09 : 22:12:19
|
| Does client machine have same sp level as on server? |
|
|
|
dzach
Starting Member
38 Posts |
Posted - 2008-06-10 : 09:14:14
|
| Enterprise Manager on the local server doesn't show any databases either, and the SPs are all the same. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-06-10 : 10:25:39
|
| zWhere does EM go to get the "list" perhaps that particular database or table is FUBAR. |
|
|
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
Posted - 2008-06-11 : 01:05:33
|
| Is the database on a shared drive? If so check whether the share is intact. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-11 : 22:51:18
|
| If that's the case, you'll see dbs in suspect status. By the way, did you connect to sql as sysadmin? |
|
|
|
|
|
|
Databases Not Showing in Enterprise Manager