Reports missing in the Configuration Manager Console

You may have seen No Items Found when looking at the Monitoring > Reporting > Reports node in the Configuration Manager console

TL;DR

One of the more common reasons for your reports to be missing is an expired certificate on your SQL Server Reporting Services Web Service

If this is the case, you will have an error on the SMS_SRS_REPORTING_POINT component. You can view the component status by: –

  1. In the Configuration Manager console, go to the Monitoring workspace, expand System Status, and select the Component Status node
  2. Select the SMS_SRS_REPORTING_POINT component
  3. On the Home tab of the ribbon, in the Component group, select Show Messages, and then choose Error
  4. Specify a date and time for a period to include the time you first started noticing an issue

Head over to your SQL Server Reporting Services Point. The server name is included in the error

Open certlm.msc and check for an expired certificate

Assuming the certificate came from your internal Certificate Authority, request a new certificate

Verify you have a valid certificate to use on your SQL Server Reporting Services point

Remove the expired certificate binding and assign the new certificate to the Web Service URL in Reporting Services Configuration Manager

Verify your component status is reset to OK

Verify the Web Service URL in Reporting Services Configuration Manager

Verify Reports are now visible in the Configuration Manager Console

You can read more about Reporting Services Configuration Manager at

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/reporting-services-configuration-manager-native-mode?view=sql-server-ver15

Leave a Comment

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.

 

This site uses Akismet to reduce spam. Learn how your comment data is processed.