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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Enterprise Manager causing Event Error

Author  Topic 

jstormoen
Starting Member

30 Posts

Posted - 2006-12-13 : 16:33:44
We have 2 sql 2000 servers running on Win 2003 (1 at SP1 and the other with now SP) that are causing the following message in the Event view when I try to look at the properties of a database - then the Enterprise manager disappears ? 1 sql server is at sp3a and the other is at SP4.

The Event Log is message is : Faulting application mmc.exe, version 5.2.3790.1830, faulting module SQLDMO.DLL, version 2000.80.194.0, fault address 0x0007b7ab.

Not much on the web for this one - any help would be appreciated

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-12-13 : 17:24:50
Have you installed sql sp3a or sp4 on the machine where EM is running?

rockmoose
Go to Top of Page

jstormoen
Starting Member

30 Posts

Posted - 2006-12-13 : 17:35:42
This only occurs if I run EM from the server I can check this info from another machine with EM on it with no problem.

One of the servers has sp3a on it and the other has sp4
Go to Top of Page

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2006-12-14 : 08:29:19
Try uninstalling (only) the SQL client tools on the server and then reinstall them.
Go to Top of Page
   

- Advertisement -