Microsoft Knowledge Base Email Alertz

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

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 902803 - Last Review: June 13, 2007 - Revision: 4.0

You receive a "Microsoft SQL Server 2000 SP3a or above required" error message when you try to install 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:
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.

STATUS

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

APPLIES TO
  • Microsoft Operations Manager (MOM) 2005
Keywords: 
kberrmsg kbfix kbtshoot kbprb KB902803
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate