Showing posts with label window. Show all posts
Showing posts with label window. Show all posts

Friday, March 23, 2012

MMC error with Enterprise Manager

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?
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).

Wednesday, March 21, 2012

Mixed mode security

Hello all,
I'm trying to modify the security setting for a local install to m ake
it mixed mode, but in the SQL Server properties window I select SQL
Server and Windows then press OK, but the window doesn't close and it
won't let me save the settings. Why is this? Can anyone help?
Thanks,
JonIt would help if you specify the version and editions
"Jon" <JonMYates@.gmail.com> wrote in message
news:1191402457.786282.106960@.57g2000hsv.googlegroups.com...
> Hello all,
> I'm trying to modify the security setting for a local install to m ake
> it mixed mode, but in the SQL Server properties window I select SQL
> Server and Windows then press OK, but the window doesn't close and it
> won't let me save the settings. Why is this? Can anyone help?
> Thanks,
> Jon
>sql