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

Rate this post

1 thought on “Reports missing in the Configuration Manager Console”

  1. I noticed your SSL port for the Web Service URL is 444 instead of 443. Is that, by any chance, because you have binding errors when you try to set it to 443, because the SMS Issuing certificate is already bound to 443 on the SCCM server? If so…maybe that’s what I need to do. I have Reporting Services installed on the same server as SCCM, and I’ve always had binding errors when I try to add our signed certificate to the Reporting Services websites.

Leave a Comment

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.

 

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