KB925480 - When you to try to install Microsoft Operations Manager 2005 Workgroup Edition Service Pack 1 on a computer that is running Microsoft SQL Server 2005, the installation fails

  • Article

Recently released to https://support.microsoft.com/kb/925480

 

SYMPTOMS

You try to install Microsoft Operations Manager (MOM) 2005 Workgroup Edition Service Pack 1 (SP1) on a computer that is running Microsoft SQL Server 2005. However, when you add the SQL Server database instance in the MOM 2005 installation dialog box, and then you click Next, the setup process cannot continue and the installation fails.

 

CAUSE

This issue occurs because MOM 2005 Workgroup Edition SP1 can only be installed in unattended mode on a computer that is running SQL Server 2005. For more information about MOM operational database and Reporting data warehouse support in SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:

917615 (https://support.microsoft.com/kb/917615/) The MOM 2005 Service Pack 1 operational database and Reporting data warehouse now support SQL Server 2005

 

RESOLUTION

To resolve this issue, you must install MOM 2005 Workgroup Edition SP1 on a computer that is running SQL Server 2005 by running Msiexec.exe in unattended mode. For example, type the following command at the command prompt to install MOM 2005 Workgroup Edition SP1 in unattended mode:

msiexec /i [PathtoCDImage]\MOMServer.msi /qn /l*v %TEMP%\MOMWorkgroupEdition.log ENABLE_ERROR_REPORTING=1 SQLSVR_INSTANCE=[ComputerName]\[SQL2005INSTANCE] ACTIONSUSER=[account] ACTIONSPASSWORD=[password] ACTIONSDOMAIN=[DOMAIN] MOM_2005_SP_INSTALL=1 MS_MPS=[PathtoCDImage]\ManagementPacks\Setup

Note This command line installation will fail when it is used on a domain controller that has SQL Server 2005 installed. This command line installation can only be used on a member server