SQL Server Performance

DL380G5 win2003 std, sql2000 std = mmc crash

Discussion in 'Performance Tuning for Hardware Configurations' started by ac427, Feb 21, 2007.

  1. ac427 New Member

    i have a new server with dual core 2 duo xeon's and 3gb of ram.

    i have installed windows2003 standard sp1, sql 2000 standard and SP4

    in Enterprise manager on the server, when i right click on any database and click properties the mmc crashes with an error in SQLDMO i can access properties via mmc on client pc's though.

    i have tried the /3GB switch but this made no difference.

    am i doing something basically wrong ?

  2. joechang New Member

  3. ac427 New Member

    Hi Joe,

    And thanks for your reply. i traced the problem to the bespoke app the server was built for. As part of it's setup MDAC 2.1 is installed, yeah i know, what price progress! I applied the post SP4 fix and mdac 2.8 but it was a reinstall of SP4 that cured the problem.



Share This Page