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
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 1Microsoft SQL Server 2000 SP3a
or above required.
Message 1SQL 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.
This problem occurs because of a design change that was
incorporated in the version format of SQL Server 2000.
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.
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
| 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