lammcspicy Posted July 31, 2014 Report post Posted July 31, 2014 Guys, I have a seperate SQL 2008 server install. Reporting service is installed and configured. I successfully configured the reporting services point in SCCM. However my reporting services point is showing critical. The log is below. Restarting the service does not resolve the issue. Any thoughts ? SMS_SRS_REPORTING_POINT 4629 Component Status Summarizer detected that the availability of component "SMS_SRS_REPORTING_POINT" on computer "sql.domain.com" has changed to Online. SMS_SITE_SYSTEM_STATUS_SUMMARIZER 4721 Site System Status Summarizer detected that the availability of the "Reporting services point" role on server "\\sql.domain.com" has changed to Failed. Possible cause: This Configuration Manager Server Role is unable to function. Solution: Verify that no security or configuration problems exist and that all related components are running. SMS_OUTBOX_MONITOR 4629 Component Status Summarizer detected that the availability of component "SMS_OUTBOX_MONITOR" on computer "sql.domain.com" has changed to Online. SMS_MP_FILE_DISPATCH_MANAGER 4629 Component Status Summarizer detected that the availability of component "SMS_MP_FILE_DISPATCH_MANAGER" on computer "sql.domain.com" has changed to Online. SMS_COMPONENT_MONITOR 4629 Component Status Summarizer detected that the availability of component "SMS_COMPONENT_MONITOR" on computer "sql.domain.com" has changed to Online. SMS_SRS_REPORTING_POINT 4610 Component Status Summarizer set the status of component "SMS_SRS_REPORTING_POINT" running on computer "sql.domain.com" to Warning. Possible cause: The component is experiencing a problem. Solution: Diagnose and fix the problem by: 1. Examine the status messages that the component reports. 2. Correcting the problem. 3. Instructing Component Status Summarizer to reset the counts of Error, Warning, and/or Informational status messages reported by the component. To reset the counts, right-click Reset Counts on the component in the Component Status summary in the Configuration Manager Console. When the counts are reset, Component Status Summarizer will change the status of the component to OK. This might take some time if site "CCM" is a child site. 4. Deleting any unwanted status messages from the site database, if necessary. 5. Monitor the component occasionally to verify the problem does not reoccur. Possible cause: The component is OK and you were unnecessarily alerted because the Component Status Thresholds are set too low for the component. Solution: Increase the Component Status Thresholds for the component using the Thresholds tab of the Component Status Summarizer Properties dialog box in the Configuration Manager Console. Possible cause: The component is "flooding" the status system by rapidly reporting the same message repeatedly. Solution: Diagnose and control the flood of status messages by: 1. Verifying that the component is actually flooding the status system. View the status messages reported by the component, and verify that the same message is continually reported every several minutes or seconds. 2. Noting the Message ID of the flooded status message. 3. Creating a Status Filter Rule for site "CCM" that instructs Status Manager to discard the flooded status message when component "SMS_SRS_REPORTING_POINT" on computer "sql.domain.comHERIFF.ORG" reports it. 4. Verifying that your sites' databases were not filled up by the flooded status message. Delete any dup Quote Share this post Link to post Share on other sites More sharing options...
lammcspicy Posted July 31, 2014 Report post Posted July 31, 2014 oh add to that - when I go to right click reports and go to report options and select my sql server I get a message there is a problem connecting to the specified reporting server. please check the connection and make sure SQL reporting service is running on the specified server" Windows firewall if off on my SQL server Quote Share this post Link to post Share on other sites More sharing options...
lammcspicy Posted July 31, 2014 Report post Posted July 31, 2014 Little more information. The log is giving an 7403 report server service is not running srsrp.log on my sql server is giving a The request failed with HTTP status 401: Unauthorized. If I try and browse to the site I just get sqlservername/ReportServer - / Quote Share this post Link to post Share on other sites More sharing options...
