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 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;
(if different from minimum)
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;
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
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.