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



The information in this article applies to:

  • Microsoft Operations Manager 2005

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.

CAUSE

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

WORKAROUND

To work around this issue, 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. Use the PREREQ_COMPLETED=1 switch to skip the MOM Prerequisite Checker.

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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Modification Type:MajorLast Reviewed:5/29/2006
Keywords:kberrmsg kbfix kbtshoot kbprb KB902803 kbAudITPRO