Battling to re-install Operations Manager 2007 Reporting Server Part - Please HELP
Hi All,
Maybe you can help me.
Something happened to my operations manager reporting installation and I need to re-install but I'm having problems.
My SCOM 2007 instance has been recently upgraded to SP1 RC. Operations Manager and Operations Manager Data warehouse is both upgraded to SP1 RC and all data is still intact.
The problem comes in when I want to re-install the Reporting Server part. The installation does not want to go through successfully it just rolls back. I'm guessing it has got something to do with the management pack versions. Any ideas? The log file does not say much and I cannot run the upgrade as it complains about missing ops manager report components.
The bad thing is that I have to generate reports tomorrow for management and reporting is not working.
Have you come across this problem before?
Regards,
Ruaan
P.S The install log file is below
Property(C): OperationalDataReportsDlg_ViewSampleReport = Click the View Report button to view a sample report
Property(C): OperationalDataReportsDlg_ViewReportButton = &View Report
Property(C): DWServerAndDBNameDlg_Title = Connect to the Operations Manager Data Warehouse
Property(C): DWServerAndDBNameDlg_Text1 = Specify the name of the SQL Server database instance that hosts the Operations Manager data warehouse.
Property(C): DWServerAndDBNameDlg_DBInstance = &SQL Server database instance
Property(C): DWServerAndDBNameDlg_DBInstance_Example = (SQL Server\SQL Instance)
Property(C): DWServerAndDBNameDlg_DBName = &SQL database name
Property(C): DWServerDlg_DBPort = SQL Server &Port
Property(C): DWServerAndDBServerErrDlg_Title1 = DW Database Server Name cannot be Blank
Property(C): DWServerAndDBServerErrDlg_Title2 = Setup cannot locate the DW database.
Property(C): DWServerAndDBServerErrDlg_Title3 = Invalid Microsoft Operations Manager DW Database Version
Property(C): DWServerAndDBServerErrDlg_Desc11 = Missing DW database server name.
Property(C): DWServerAndDBServerErrDlg_Desc12 = To continue setup, go back and provide the database server computer name which hosts the Microsoft Operations Manager DW database.
Property(C): DWServerAndDBServerErrDlg_Desc21 = Setup could not locate the DW database on the specified server.
Property(C): DWServerAndDBServerErrDlg_Desc22 = To change the DW database server or SQL Server port information, click Back.
Property(C): DWServerAndDBServerErrDlg_Desc23 = Verify that Microsoft SQL Server is running and that the DW database is installed on the specified server, and that you have access to the DW database
Property(C): DWServerAndDBServerErrDlg_Desc31 = Setup found that the Microsoft Operations Manager database version on the specified database server is not same as the current product version.
Property(C): DWServerAndDBServerErrDlg_Desc32 = To continue setup, go back and either change the database server name or upgrade the SC database on the specified server to the current version.
Property(C): OperationalDataReportsSampleDlg_Title = Operational Data Reports Sample
Property(C): SRSDlg_Title = SQL Server Reporting Services Instance
Property(C): SRSDlg_Desc = Select the SQL instance for Reporting Services
Property(C): SRSDlg_SRS = Enter the SQL Server Reporting Services &Server:
Property(C): SRSDlg_Desc2 = Warning: The Installation of System Center Operations Manager 2007 will integrate the security of the chosen SQL Reporting Services Server Instance with OM 2007 role-based security. Any reports previously installed on this Instance may become inaccessible.
Property(C): SRSHttpBindingsDlg_Title = SQL Server Reporting Services Server
Property(C): SRSHttpBindingsDlg_Desc = Select the SQL Reporting Services Website
Property(C): SRSHttpBindingsDlg_BindingTitle = Select the &Website address you wish to use:
Property(C): SRSHttpBindingsDlg_ServerName = SQL Server Reporting Services Server:
Property(C): SRSHttpBindingsDlg_ReportServerVDir = Report Server Virtual Directory (e.g. ReportServer)
Property(C): SRSHttpBindingsDlg_ReportManagerVDir = ReportManager Virtual Directory (e.g. Reports)
Property(C): ClusterWarningCheck_Caption = &Passive node of a Windows Server Cluster
Property(C): UpgradeMOMXDlg_Text = Click Next to upgrade.
Property(C): SecureCustomProperties = ACTIONSPASSWORD;DATAREADER_PASSWORD;DBWRITEACTIONSPASSWORD;DOTNET20INSTALLED;MOM_DB_SERVER;MOMREPORTINGDBNAME_OLD;REPORTING_NEWER_PRODUCT_FOUND;REPORTING_PRODUCT_FOUND;SDK_PASSWORD.540EA3C0_A5E9_41EA_A585_822C09EA2650;SQL_PORT
Property(C): MsiHiddenProperties = _CreateAndAddRunAsAccountsCA;_ManagementGroupConnect;_ManagementGroupDisconnect;_Rollback_ManagementGroupConnect;_Set_CreateAndAddRunAsAccountsCA.9B663534_CD9B_41CC_9D93_4E84D3C5E165;_Set_ManagementGroupConnect.9B663534_CD9B_41CC_9D93_4E84D3C5E165;_Set_ManagementGroupDisconnect.9B663534_CD9B_41CC_9D93_4E84D3C5E165;_Set_Rollback_ManagementGroupConnect.9B663534_CD9B_41CC_9D93_4E84D3C5E165;_Set_SetSRSAccount.9B663534_CD9B_41CC_9D93_4E84D3C5E165;_Set_SetSRSSecurityCA.9B663534_CD9B_41CC_9D93_4E84D3C5E165;_SetConfigServiceAccount.540EA3C0_A5E9_41EA_A585_822C09EA2650;_SetSDKServiceAccount.540EA3C0_A5E9_41EA_A585_822C09EA2650;_SetSRSAccount;_SetSRSSecurityCA;_StoreActionsAccount.80B659D9_F758_4E7D_B4FA_E53FC737DCC9;ACTIONSPASSWORD;DATAREADER_PASSWORD;DBWRITEACTIONSPASSWORD;SDK_PASSWORD.540EA3C0_A5E9_41EA_A585_822C09EA2650
Property(C): DB_DATA_DIR = D:\Program Files\System Center Operations Manager 2007\Reporting\MSSQL\data\
Property(C): DB_LOG_DIR = D:\Program Files\System Center Operations Manager 2007\Reporting\MSSQL\data\
Property(C): VersionNT = 502
Property(C): SQLSVR_INSTANCE = ctbbcysql04
Property(C): INSTALLDIR = D:\Program Files\System Center Operations Manager 2007\
Property(C): TempDataDir = D:\Program Files\System Center Operations Manager 2007\Reporting\MSSQL\data\
Property(C): TempLogDir = D:\Program Files\System Center Operations Manager 2007\Reporting\MSSQL\data\
Property(C): USERNAME = First National Bank
Property(C): COMPANYNAME = First National Bank
Property(C): _BrowseProperty = INSTALLDIR
Property(C): Sql_Instance = ctbbcysql04
Property(C): DBWRITEACTIONSUSER = s_scom_sdk
Property(C): DBWRITEACTIONSPASSWORD = **********
Property(C): DBWRITEACTIONSDOMAIN = SCDOMAIN1
Property(C): DATAREADER_USER = s_scom_sdk
Property(C): DATAREADER_PASSWORD = **********
Property(C): DATAREADER_DOMAIN = SCDOMAIN1
Property(C): SRS_SERVER = CTBBCYSRS01-V
Property(C): REPORT_SERVER_FULL_HTTP_PATH = http://CTBBCYSRS01-V:80/ReportServer
Property(C): REPORT_SERVER_VDIR = ReportServer
Property(C): REPORT_MANAGER_VDIR = Reports
Property(C): MGSERVER = ctbbcyscm01-rms
Property(C): MOM_INSTALL_DIR = C:\Program Files\System Center Operations Manager 2007\
Property(C): DOTNET20INSTALLED = #1
Property(C): REPORTINGDIR = D:\Program Files\System Center Operations Manager 2007\Reporting\
Property(C): SQLROOTDATADIR = D:\Program Files\System Center Operations Manager 2007\Reporting\MSSQL\
Property(C): ProgramFilesFolder = C:\Program Files\
Property(C): TARGETDIR = D:\
Property(C): SourceDir = \\apache\SCOM07\reporting\i386\
Property(C): ROSETTA_SERVER = CTBBCYSRS01-V
Property(C): PrereqReportName = C:\DOCUME~1\S_SCOM~2\LOCALS~1\Temp\2\PrereqReport.xml
Property(C): PrereqViewer = C:\DOCUME~1\S_SCOM~2\LOCALS~1\Temp\2\PrereqViewer.exe
Property(C): Privileged = 1
Property(C): DatabaseModuleDir.128A4B6A_C876_40B8_83B5_2793414E2138 = D:\Program Files\System Center Operations Manager 2007\Reporting\
Property(C): DATABASE_DIR = D:\Program Files\System Center Operations Manager 2007\Reporting\Database\
Property(C): REPORTSFOLDER.9B663534_CD9B_41CC_9D93_4E84D3C5E165 = D:\Program Files\System Center Operations Manager 2007\Reporting\Reports\
Property(C): DWReportLibrary.9B663534_CD9B_41CC_9D93_4E84D3C5E165 = D:\Program Files\System Center Operations Manager 2007\Reporting\Reports\Microsoft.SystemCenter.DataWarehouse.Report.Library\
Property(C): SDK_DIR.9B663534_CD9B_41CC_9D93_4E84D3C5E165 = D:\Program Files\System Center Operations Manager 2007\Reporting\
Property(C): SRSFILEFOLDER = d:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\bin
Property(C): REPORTINGFOLDER = /
Property(C): MYREPORTSFOLDER = My Reports
Property(C): MOM_SRS_ASSEMBLY_NAME.9B663534_CD9B_41CC_9D93_4E84D3C5E165 = Microsoft Operations Manager Reporting Code Assembly
Property(C): MOM_SRS_ASSEMBLY_DESC.9B663534_CD9B_41CC_9D93_4E84D3C5E165 = Grants the MOM Reporting Code assembly full trust permission.
Property(C): CHARTING_ASSEMBLY_NAME.9B663534_CD9B_41CC_9D93_4E84D3C5E165 = EnterpriseChartControl
Property(C): CHARTING_ASSEMBLY_DESC.9B663534_CD9B_41CC_9D93_4E84D3C5E165 = This codegroup grants FullTrust to EnterpriseChartControl assemblies.
Property(C): NetFxVersion = v2.0.50727
Property(C): TOOLS.68918168_3885_4F75_BBF8_0CC84213F8D1 = D:\Program Files\System Center Operations Manager 2007\Tools\
Property(C): PackageCode = {7164D0F8-3AEA-4994-ABE0-560481D11BA6}
Property(C): ProductState = -1
Property(C): PackagecodeChanging = 1
Property(C): CURRENTDIRECTORY = \\apache\SCOM07
Property(C): CLIENTUILEVEL = 0
Property(C): CLIENTPROCESSID = 3056
Property(C): VersionDatabase = 200
Property(C): VersionMsi = 3.01
Property(C): WindowsBuild = 3790
Property(C): ServicePackLevel = 1
Property(C): ServicePackLevelMinor = 0
Property(C): MsiNTProductType = 3
Property(C): WindowsFolder = C:\WINDOWS\
Property(C): WindowsVolume = C:\
Property(C): SystemFolder = C:\WINDOWS\system32\
Property(C): System16Folder = C:\WINDOWS\system\
Property(C): RemoteAdminTS = 1
Property(C): TempFolder = C:\DOCUME~1\S_SCOM~2\LOCALS~1\Temp\2\
Property(C): CommonFilesFolder = C:\Program Files\Common Files\
Property(C): AppDataFolder = C:\Documents and Settings\s_scom_aa\Application Data\
Property(C): FavoritesFolder = C:\Documents and Settings\s_scom_aa\Favorites\
Property(C): NetHoodFolder = C:\Documents and Settings\s_scom_aa\NetHood\
Property(C): PersonalFolder = C:\Documents and Settings\s_scom_aa\My Documents\
Property(C): PrintHoodFolder = C:\Documents and Settings\s_scom_aa\PrintHood\
Property(C): RecentFolder = C:\Documents and Settings\s_scom_aa\Recent\
Property(C): SendToFolder = C:\Documents and Settings\s_scom_aa\SendTo\
Property(C): TemplateFolder = C:\Documents and Settings\All Users\Templates\
Property(C): CommonAppDataFolder = C:\Documents and Settings\All Users\Application Data\
Property(C): LocalAppDataFolder = C:\Documents and Settings\s_scom_aa\Local Settings\Application Data\
Property(C): MyPicturesFolder = C:\Documents and Settings\s_scom_aa\My Documents\My Pictures\
Property(C): AdminToolsFolder = C:\Documents and Settings\All Users\Start Menu\Programs\Administrative Tools\
Property(C): StartupFolder = C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(C): ProgramMenuFolder = C:\Documents and Settings\All Users\Start Menu\Programs\
Property(C): StartMenuFolder = C:\Documents and Settings\All Users\Start Menu\
Property(C): DesktopFolder = C:\Documents and Settings\All Users\Desktop\
Property(C): FontsFolder = C:\WINDOWS\Fonts\
Property(C): GPTSupport = 1
Property(C): OLEAdvtSupport = 1
Property(C): ShellAdvtSupport = 1
Property(C): Intel = 6
Property(C): PhysicalMemory = 1024
Property(C): VirtualMemory = 3664
Property(C): AdminUser = 1
Property(C): LogonUser = s_scom_aa
Property(C): UserSID = S-1-5-21-1355446046-407258478-314601362-38723
Property(C): UserLanguageID = 7177
Property(C): ComputerName = CTBBCYSRS01-V
Property(C): SystemLanguageID = 7177
Property(C): ScreenX = 1440
Property(C): ScreenY = 900
Property(C): CaptionHeight = 19
Property(C): BorderTop = 1
Property(C): BorderSide = 1
Property(C): TextHeight = 16
Property(C): ColorBits = 16
Property(C): TTCSupport = 1
Property(C): Time = 19:46:21
Property(C): Date = 2008/01/31
Property(C): MsiNetAssemblySupport = 2.0.50727.42
Property(C): MsiWin32AssemblySupport = 5.2.3790.1830
Property(C): RedirectedDllSupport = 2
Property(C): DATABASE = C:\DOCUME~1\S_SCOM~2\LOCALS~1\Temp\2\1287e29.msi
Property(C): OriginalDatabase = \\apache\SCOM07\reporting\i386\Reporting2007.msi
Property(C): SOURCEDIR = \\apache\SCOM07\reporting\i386\
Property(C): VersionHandler = 3.01
Property(C): UILevel = 5
Property(C): ACTION = INSTALL
Property(C): EXECUTEACTION = INSTALL
Property(C): ROOTDRIVE = D:\
Property(C): CostingComplete = 1
Property(C): OutOfDiskSpace = 0
Property(C): OutOfNoRbDiskSpace = 0
Property(C): PrimaryVolumeSpaceAvailable = 0
Property(C): PrimaryVolumeSpaceRequired = 0
Property(C): PrimaryVolumeSpaceRemaining = 0
Property(C): PREREQ_COMPLETED = 1
Property(C): IsWarehouseOwnerAccountGood = 1
Property(C): MANAGEMENT_GROUP = CTBIT
Property(C): SRS_INSTANCE_REGISTRY_LOCATION = MSSQL.1
Property(C): MGDATABASE = OperationsManager
Property(C): resolvedMG = 1
Property(C): SRS_SERVICE_NAME = ReportServer
Property(C): MGSQLSERVER = CTBBCYSQL04
Property(C): IsDBWriteActionsAccountGood = 1
Property(C): SRS_WEB_SERVICE_GROUP_NAME = SQLServer2005ReportingServicesWebServiceUser$CTBBCYSRS01-V$MSSQLSERVER
Property(C): SRSREPORTSERVERFOLDER = d:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\
Property(C): REPORT_SERVER_FULL_HTTP_PATH_VALID = 1
Property(C): SRS_SQL_DATABASENAME = ReportServer
Property(C): SRS_SQL_INSTANCE = ctbbcysql04
Property(C): SRS_INSTANCE_NAME = MSSQLSERVER
Property(C): SRSCONFIGFILE = d:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\rssrvpolicy.config
=== Logging stopped: 2008/01/31 19:46:21 ===
MSI (c) (F0:C4) [19:46:21:153]: Note: 1: 1708
MSI (c) (F0:C4) [19:46:21:153]: Product: System Center Operations Manager 2007 Reporting Server -- Installation operation failed.MSI (c) (F0:C4) [19:46:21:153]: Grabbed execution mutex.
MSI (c) (F0:C4) [19:46:21:153]: Cleaning up uninstalled install packages, if any exist
MSI (c) (F0:C4) [19:46:21:153]: MainEngineThread is returning 1603
=== Verbose logging stopped: 2008/01/31 19:46:21 ===
All Replies
Did you have any luck with this problem RuuanD ??
Same exact thing here as well.... aside from a server re-build I guess there is no solution.
-DDF