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: date
Time: time
User: user name
Computer: computer name
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}
This problem occurs when the following conditions are true:
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 "\\path\momreporting.msi" /lv* D:\logs\REPORTING_Install.log MOM_DB_SERVER="computer name\Instance" SQLSVR_INSTANCE="computer name\Instance" TASK_USER_ACCOUNT="MOM DTS account" TASK_USER_DOMAIN="domain name" TASK_USER_PASSWORD="password" REPORTING_USER="MOM Reporting account" REPORTING_DOMAIN="domain" REPORTING_PASSWORD="password" ROSETTA_SERVER="computer name" PREREQ_COMPLETED="1" REPORT_SERVER_VDIR="ReportServer" REPORT_MANAGER_VDIR="Reports" AUTOMATICALLY_DETECT_ROSETTA_VDIRS="0" /Qn
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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:
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=917615/
)
The MOM 2005 Service Pack 1 operational database and Reporting data warehouse now support SQL Server 2005