Microsoft KB Archive/902803

From BetaArchive Wiki
Knowledge Base


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

Article ID: 902803

Article Last Modified on 6/13/2007



APPLIES TO

  • Microsoft Operations Manager (MOM) 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 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:

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.


Additional query words: Server Management 51938 sp3

Keywords: kberrmsg kbfix kbtshoot kbprb KB902803