Using SQL Server 2000 SP3 Developer Edition and MDAC 2.7
After installing SP3 to my desktop to inoculate against the Slammer worm, Enterprise Manager started crashing with the following whenever I try to open database properties with the following: The instruction at "0x4247b98b" referenced memory at "0x0000001c" could not be 'read'. I've reinstalled SQL Server and the MDAC to no avail. Has anyone else had this and are there any ideas for possible solutions?
ThanksYou might want to take a look at the error log to see which component is failing. There is a known issue with DTSUI.DLL after installing sp3. You will have to contact PSS to get the fix.
G'luck.|||Get SQLDMO.DLL from \Program Files\Microsoft SQL Server\80\Tools\Binn and SQLDMO.rll from Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 and Register it again using the REGSVR32 command.
We use to have the same problem now everything seems to be working fine.|||I was never able to get sqldmo.rll to register, as regsvr32 said that it only liked to register dll's and ocx's. But, moving the 2 files to the system32 folder replaced some really old ones and fixed the problem. Thanks for your help!|||Just be carefule the next time when you uninstall any user application as it tends to take away the SQLDMO.dll,which again results in the same thing.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment