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;  


ENVIRONMENT




  • 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; 



Failures


Minimum Requirement
 Recommended
(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 http://www.microsoft.com/downloads/


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




  • SELECT SERVERPROPERTY(‘ProductLevel’)


  • SELECT @@VERSION


  • SELECT SERVERPROPERTY(‘ProductVersion’)

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
 @@VERSION
 Product Level
 
SQL Server 2000 Original Release
 8.00.194
 RTM
 
Database Components SP1
 8.00.384
 SP1
 
Database Components SP2
 8.00.534
 SP2
 
Database Components SP3, SP3a or MSDE 2000 Release A.
 8.00.760
 SP3
 
Database Components SP4
 8.00.2039
 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.


MORE INFORMATION


http://support.microsoft.com/default.aspx?scid=kb;en-us;902803


http://www.microsoft.com/technet/prodtechnol/mom/mom2005/Library/be9f9412-c93f-4e6a-8b3e-586395cfdac4.mspx


http://blog.bernt.net/2005/07/russ-kaufmann-mom-2005-and-sql-server.html


http://cs.thefoleyhouse.co.uk/blogs/karl/archive/2005/07/02/456.aspx


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.

    End

  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 *