Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Location
    Nashville, TN
    Posts
    6

    Unhappy Unanswered: Enterprise Manager crashes

    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?

    Thanks

  2. #2
    Join Date
    May 2002
    Posts
    299

    Re: Enterprise Manager crashes

    You 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.
    --
    -oj
    http://www.rac4sql.net

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    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.

  4. #4
    Join Date
    Feb 2003
    Location
    Nashville, TN
    Posts
    6
    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!

  5. #5
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •