MOM 2005 and SQL Server 2000 SP4 – Original Posted Jun 27, 2005

What in the world was Microsoft thinking?

 

I was installing MOM 2005 and found out that it is not possible to install the MOM 2005 Database on a SQL Server 2000 server with SP4. WTF? That just doesn’t make sense.

 

Supposedly this will be fully supported with MOM 2005 SP1. Umm, that just doesn’t work for me. So, time to research. Thanks to Neil Hobson, a MOM MVP, a workaround has been published in the MOM 2005 public newsgroup. It is a registry hack, but at least it is a supported registry hack. What needs to be done is that you have to alter the CSDVersion entry located at:

HKEY_Local_Machine\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

If SP4 is installed, the version number will be 8.00.2039. To get the MOM 2005 Database to install, you need to change the version number to 8.00.761 which is the same one for SP3A and then change it back again after the installation is completed.

 

Somebody needs to be slapped over this one.

 

Updated 7/28/05 – Microsoft provides another workaround for this same problem. You can use the msiexec command with the PREREQ_COMPLETED=1 switch to skip the MOM Prerequisite Checker. See KB 902803 for more information.

Leave a Reply

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