MMC error with Enterprise Manager

15 Nov 2005 10:36 PM

B. Mark McKinney

When attempting to display a database's property window in Enterprise Manager
an error happens with MMC. On a machine that also has SQL Server 2005 client
tools installed Enterprise manager crashes. On other machines that do not
have SQL Server 2005 client tools installed, MMC throws an error similar to
the one below before Enterprise Manager crashes:

mmc.exe Application error The instruction at "0x7801094 referenced
memory......

The exact memory address in the above error message is not correct. I copied
it from another reference (on Google) dealing with DTS / MMC errors. I do not
have the exact message because I was forced to reinstall SQL Server 2000 in
order to use the RTM version to get around this error. The bug does not
happen in the RTM version but does with both SP3 and SP4.

The problem started fairly recently and I suspect it has to do with a
Microsoft update. It is happening to every computer computer in our facility
that has service packs applied to SQL Server and affects more than the
ability to display a databases property page.

Does anyone have any knowledge as to what might be causing these errors with
MMC and whether or not there is a work around?

16 Nov 2005 11:49 PM

B. Mark McKinney

I have now applied SP4 again and can replicate the error again.

When I right click on a Database in Enterprise Manager and select properties
I receive the following message:

mmc.exe - Application Error
The instruction at "0x4247b98b" referenced memory at "0x0000001c". The
memory could not be read.
Click OK to terminate.....

I am running SQL Server 2000 on Windows 2000 (SP4).