Installing MOM 2005 on SQL 2000 SP4

Hello everyone and after a long time, I am back to the community. I have changed my employer and I am now working for Atos Origin Middle East.  

So, today I started to play with MOM2005 in my test-bed and encountered with couple of issues which I really wanted to share;  


  • Windows Server 2003 SP1 with all the latest updates.

  • SQL 2000 SP4.

Ok, fair enough and I installed SQL 2000 SP4 without any glitches. One thing to remember here is the MSSQLSERVER SERVICE will not start automatically and you have to start it manually. 

Now, I ran the Check Prerequisites wizard (The Prerequisite Check page indicates whether you have met all the requirements for installing the MOM components) to check the following Selected Components: 

  • MOM Database.

  • MOM User Interfaces.

  • MOM Management Server.

The prerequisite check failed for the selected components. The reason being MOM setup is unable to detect SQL Server 2000 SP4; 


Minimum Requirement
(if different from minimum)
 Required For
 Detected Value  
Microsoft SQL Server 2000 SP3 or later. SQL Server 2000 SP3 or later not detected

Download the required version from

I quickly ran SQL Query Analayser to check if the SP4 is installed to execute the following queries;




As expected the result is SP4 8.00.2039 [Microsoft SQL Server  2000 – 8.00.2039 (Intel X86)   May  3 2005 23:18:38   Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)]

As always, I am back to community for help and started the following thread MOM prerequisite check failed. Thanks to Ronny for guiding to support kb article You receive a ” Microsoft SQL Server 2000 SP3a or above required” error message when you try to install MOM 2005. I then found Technet article, ‘Troubleshoot MOM 2005 Prerequisite Checking’ which further explained this BUG.

Instead of executing msiexec command with PREREQ_COMPLETED=1, I found another cheeky workaround where in you can tweak the registry to SQL SP3. For more information see the table below;

SQL Server 2000 Version and Level
 Product Level
SQL Server 2000 Original Release
Database Components SP1
Database Components SP2
Database Components SP3, SP3a or MSDE 2000 Release A.
Database Components SP4

All I have to do is to edit the registry from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion – value name “CSDVersion = 8.00.2039 to a new value of 8.00.760” which essentially means SQL SP3. Now, just run the MOMPreReqReport to make sure there are no errors and just run the installer again with success!! Dont forget to revert back to CSDVersion = 8.00.2039.


Happy Testing!

8 thoughts on “Installing MOM 2005 on SQL 2000 SP4

  1. Thanks for that, it was annoying me. You would of thought a clean install and the latest sevice pack for SQL would have been the best route to go. I wasted a lot of time reapplying the pack and re-installing SQL.

  2. The above workaround works fine. I only wished I looked before re-installed Microsoft SQL Server 2000 with sp # 4.


  3. Thank you!!! Been battling with the SP4 thing for a while…… I would say that after you do the install, you should correct the SQL version so it thinks its SP4 again…

Leave a Reply

Your email address will not be published. Required fields are marked *