You receive a "Microsoft SQL Server 2000 SP3a or above required" error message when you try to install MOM 2005

View products that this article applies to.

SYMPTOMS

When you try to install Microsoft Operations Manager (MOM) 2005 or MOM 2005 Reporting Services on a computer that has Microsoft SQL Server 2000 Service Pack 4 installed, you receive one or more error messages that resemble the following error messages.

Message 1

Microsoft SQL Server 2000 SP3a or above required.

Message 1

SQL Server 2000 SP3 or later not detected.

The message varies with the version of SQL Server and occurs when you start to install MOM 2005 Database components. The MOM Prerequisite Checker generates this message.

Back to the top

CAUSE

This problem occurs because of a design change that was incorporated in the version format of SQL Server 2000.

Back to the top

WORKAROUND

To work around this problem, run the MOM Prerequisite Checker to determine whether all the prerequisites, except for Microsoft SQL Server 2000 SP3a, are installed. Then, use the msiexec command to install MOM 2005 Database components on the proposed MOM SQL Server Database computer. Use the PREREQ_COMPLETED=1 switch to skip the MOM Prerequisite Checker.

Note The MOMServer.msi file from the MOM installation media must be available. For more information about the command-line properties of the MOMServer.msi file, refer to the Microsoft Operations Manager 2005 Deployment Guide. To obtain this guide, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=03594dca-da65-44eb-875f-0ab4928cbfbd (http://www.microsoft.com/downloads/details.aspx?FamilyID=03594dca-da65-44eb-875f-0ab4928cbfbd)

Use the following msiexec command syntax:

msiexec /i [Location of MOMServer.msi] /qn /l*v [location for log file] 
ADDLOCAL="MOMXDB" SQLSVR_INSTANCE=[MACHINENAME\SQLINSTANCE] 
DAS_ACCOUNT=[accountname] DAS_DOMAIN=[accountdomain] DAS_PASSWORD=[accountpassword] 
DB_SIZE=[sizeofMOMDB] CONFIG_GROUP= [Management Group Name]
 PREREQ_COMPLETED=1

Note If you have local administrator credentials, you can run this command on the computer where you want to install MOM 2005 Database components.

Back to the top