Installing Ops Manager 2007 R2 Reporting on SQL 2008 SP1

Todd Eichmann

2009-08-18 14:39:02 UTC

AH HA!!!! "ResetSRS.exe" is the key!

After talking to the DBA's, walking through the SQL error logs, walking
through the MOMReporting log, and coming up completely empty, I stumbled
across the "SupportTools" directory on the R2 installation media. I saw the
"ResetSRS.exe" executable and after a could Internet searches, I figured I
didn't have anything to lose, so I ran it and then ran the installation
(again).

IT FINISHED! WooHOO! I really hope that this helps someone else in the
predicament.

Post by Todd Eichmann
I've been busting my head over the installation of Ops Manager on a SQL 2008
instance for about three days now, and I'm running out of ideas. The
installation hums along fine - it finds the instances, server names, etc. -
<snip>
2009-08-17T12:16:40.6806230-05:00 Debug: Max reties: 5
2009-08-17T12:16:40.6962483-05:00 Debug: Setting retry count to:5
2009-08-17T12:16:40.6962483-05:00 Debug: More: 5 rety to go..
2009-08-17T12:17:00.0403697-05:00 Warn: Message:SetSRSEnableMyReportsCA
SoapException Exception: System.Web.Services.Protocols.SoapException: An
internal error occurred on the report server. See the error log for more
details. --->
An internal error occurred on the report server. See the error log for more
details.
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSystemProperties(Property Properties)
at
Microsoft.ReportingServices.WebServer.ReportingService2005.SetSystemProperties(Property Properties). Will retry..
2009-08-17T12:17:00.0403697-05:00 Warn: Extra data:<detail><ErrorCode
xmlns="http://www.microsoft.com/sql/reportingservices">rsInternalError</ErrorCode><HttpStatus
xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message
xmlns="http://www.microsoft.com/sql/reportingservices">An internal error
occurred on the report server. See the error log for more
details.</Message><HelpLink
xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.2531.0</HelpLink><ProductName
xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server
Reporting Services</ProductName><ProductVersion
xmlns="http://www.microsoft.com/sql/reportingservices">10.0.2531.0</ProductVersion><ProductLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem
xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation
xmlns="http://www.microsoft.com/sql/reportingservices"><Source>Microsoft.ReportingServices.Authorization</Source><Message
msrs:ErrorCode="rsInternalError"
msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.2531.0"
xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An internal error
occurred on the report server. See the error log for more
details.</Message></MoreInformation><Warnings
xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>
2009-08-17T12:17:00.0403697-05:00 Debug: Now Sleeping for : 60000 milliseconds
2009-08-17T12:18:00.0415217-05:00 Debug: More: 4 rety to go..
</snip>
<snip>
2009-08-17T12:21:04.5294388-05:00 Error: All retrys failed!!.
Message:SetSRSEnableMyReportsCA SoapException, now
throwing:System.Web.Services.Protocols.SoapException: An internal error
occurred on the report server. See the error log for more details. --->
An internal error occurred on the report server. See the error log for more
details.
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSystemProperties(Property Properties)
at
Microsoft.ReportingServices.WebServer.ReportingService2005.SetSystemProperties(Property Properties)
2009-08-17T12:21:04.5294388-05:00 Error: StackTrace: at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object parameters)
at
Microsoft.Reporting.Setup.ReportService.ReportingService2005.SetSystemProperties(Property Properties)
at
Microsoft.Reporting.Setup.ReportingManagedCAs.SetSRSEnableMyReportsCA(Session
session)
2009-08-17T12:21:04.5294388-05:00 Error: Error:SetSRSEnableMyReportsCA
error, System.Web.Services.Protocols.SoapException: An internal error
occurred on the report server. See the error log for more details. --->
An internal error occurred on the report server. See the error log for more
details.
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSystemProperties(Property Properties)
at
Microsoft.ReportingServices.WebServer.ReportingService2005.SetSystemProperties(Property Properties)
2009-08-17T12:21:04.5294388-05:00 Error: StackTrace: at
Microsoft.SystemCenter.Setup.RetryLog.ProcessException(String strMsg,
Exception e, String strExtra)
at
Microsoft.Reporting.Setup.ReportingManagedCAs.SetSRSEnableMyReportsCA(Session
session)
MSI (s) (94:CC) [12:21:04:560]: NOTE: custom action
_SetSRSEnableMyReports.9B663534_CD9B_41CC_9D93_4E84D3C5E165 unexpectedly
closed the hInstall handle (type MSIHANDLE) provided to it. The custom action
should be fixed to not close that handle.
Action ended 12:21:04: InstallFinalize. Return value 3.
</snip>
I've gone through this log top to bottom and cannot find the reason why this
installation is failing. If anyone has any ideas, I would sure like to hear
them! (sorry for the log dump - I really hope it's useful.)