Microsoft KB Archive/922337

= When you to try to install Microsoft Operations Manager 2005 Reporting on a computer that is running Microsoft SQL Server 2005, the installation fails =

Article ID: 922337

Article Last Modified on 8/21/2007

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 2005

-





SYMPTOMS
When you to try to install Microsoft Operations Manager (MOM) 2005 Reporting on a computer that is running Microsoft SQL Server 2005, the installation fails. Additionally, the following error may be logged in the System event log:

Event Type: Error

Event Source: MsiInstaller

Event Category: None

Event ID: 10005

Date:

Time:

User:

Computer:

Description:

Product: Microsoft Operations Manager 2005 Reporting -- Error 25316. WMI error accessing SQL Services Reporting Server. Error Code: -2147467259 (Unspecified error).

For more information, see Help and Support Center at http://support.microsoft.com.

Data:

0000: 7b 36 33 43 38 34 37 43 {63C847C

0008: 36 2d 30 37 41 30 2d 34 6-07A0-4

0010: 41 36 46 2d 38 41 37 38 A6F-8A78

0018: 2d 38 41 30 36 36 43 39 -8A066C9

0020: 46 39 37 37 33 7d F9773}



CAUSE
This problem occurs when the following conditions are true:  You try to install MOM 2005 Reporting on a computer that is running a 32-bit version of Microsoft SQL Server 2005. The 32-bit version of SQL Server 2005 is running on a cluster that is based on a 64-bit version of Microsoft Windows Server 2003. You do not provide the full Microsoft Windows Installer path in the command line. For example, you type a command that resembles the following:

msiexec /i momreporting.msi SQLSVR_INSTANCE=MOM ROSETTA_SERVER= TASK_USER_ACCOUNT=S-  TASK_USER_PASSWORD=  TASK_USER_DOMAIN=SPS REPORTING_USER=S-  REPORTING_PASSWORD=  REPORTING_DOMAIN=  MOM_DB_SERVER= \MOMvAUTOMATICALLY_DETECT_ROSETTA_VDIRS=1 REPORT_SERVER_URL=ReportServer REPORT_URL=Reports PREREQ_COMPLETED=1 /l* c:\mom.log /qn





RESOLUTION
To resolve this problem, type the full Windows Installer path in the command that you type when you install MOM 2005 Reporting. For example, type a command that resembles the following:

msiexec.exe /i &quot;\\ \momreporting.msi&quot; /lv* D:\logs\REPORTING_Install.log MOM_DB_SERVER=&quot; \ &quot; SQLSVR_INSTANCE=&quot; \ &quot; TASK_USER_ACCOUNT=&quot; &quot; TASK_USER_DOMAIN=&quot; &quot; TASK_USER_PASSWORD=&quot; &quot; REPORTING_USER=&quot; &quot; REPORTING_DOMAIN=&quot; &quot; REPORTING_PASSWORD=&quot; &quot; ROSETTA_SERVER=&quot; &quot; PREREQ_COMPLETED=&quot;1&quot; REPORT_SERVER_VDIR=&quot;ReportServer&quot; REPORT_MANAGER_VDIR=&quot;Reports&quot; AUTOMATICALLY_DETECT_ROSETTA_VDIRS=&quot;0&quot; /Qn



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
Under certain conditions, you must install MOM 2005 Reporting by using the MSIExec command. For example, install MOM 2005 Reporting by using the MSIExec command when you are using a configuration that resembles the following:
 * A MOM server that is running the following software:
 * A 32-bit version of Windows Server 2003 R2
 * The MOM Management service
 * The Management Web console
 * Microsoft Management Console (MMC)
 * A SQL Server 2005 cluster that is configured as follows:
 * First node configuration
 * A 64-bit version of Windows Server 2003 R2
 * Microsoft ASP.NET 1.1 and ASP.NET 2.0
 * SQL Server non-clustered instances
 * A named instance of SQL Server 2005 Standard Edition (32-bit) that is hosting the MOM OnePoint database
 * A named instance of SQL Server 2005 Standard Edition (32-bit) that is hosting the Reporting Services database
 * Second node configuration
 * A 64-bit version of Windows Server 2003 R2
 * ASP.NET 2.0
 * SQL Server clustered instances
 * A default instance of SQL Server 2005 Standard Edition (32-bit)
 * A named instance of SQL Server 2005 Standard Edition (32-bit)

If you are running this sample configuration, you must install MOM 2005 Reporting by using the MSIExec command. You cannot select a non-clustered instance by using the MOM 2005 Reporting Service Setup Wizard. Although you can select the clustered 64-bit version of SQL Server by using the wizard, this version of SQL Server 2005 is not supported. To install MOM 2005 Reporting on the supported version of SQL Server 2005 (32-bit), run the MSIExec command.

However, the MSIExec command that is documented on the following Microsoft Web site does not run successfully for the sample configuration:

http://www.microsoft.com/technet/prodtechnol/mom/mom2005/Library/1c32acb1-a241-495c-ab82-be71a3757cfc.mspx?mfr=true

The MSIExec command fails because the full path of the .msi file must be specified in the command line.

For more information about supported Microsoft SQL Server 2005 configurations, click the following article number to view the article in the Microsoft Knowledge Base:

917615 The MOM 2005 Service Pack 1 operational database and Reporting data warehouse now support SQL Server 2005

Keywords: kbtshoot kbprb KB922337

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.