Support Tip: No reports show up in the console after installing a System Center 2012 Configuration Manager Reporting server

imageHi everyone, Prabhat Joshi here. After installing and configuring a System Center 2012 Configuration Manager Reporting server, you may find that you are unable to find any reports in the Reporting workspace in the Operations console. When checking the srsrp.log file you may also see the following error:

Failures reported during periodic health check by the SRS Server

When browsing to the Report Manager URL (e.g. http://<SQLserverName>/Reports) you will receive the following error message:

HTTP Error 404.0 - Not Found
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

This can occur if there is a port conflict on the server. In our case, there was a named SQL instance as well as the default instance that we were using (MSSQLSERVER) and both were configured to use port 80 on "All Available Networks".

If you find yourself in this situation, here’s one thing you can do to resolve the issue:

1. Change the Default Instance (MSSQLSERVER) configuration to use port 8080 in the Report Manager Configuration and restart the Report Manager Service.

2. Add TCP port 8080 to the Incoming Firewall rules.

3. Reinstall Reporting services.

Once you do this you should see all of your reports and Reporting services should function as expected.

Troubleshooting Additional Causes

This issue can occur due to multiple reasons so an understanding of entire process that involves integration of SQL reporting services with Configuration Manager can be helpful. Here are the steps I go through along with some additional troubleshooting tips:

1. Install SQL server reporting services.

2. Configure a DB.

3. Check the server. If none of the reports are deployed to the report server, browsing to a working report server URL should simply show the reporting services version (e.g. if it’s SSRS 2008 R2 RTM, the version displayed would be 10.50.1600.1)

4. If you get any errors while browsing the report server URL, it’s highly likely that the report manager URL would also fail. If this is the case, the first thing to do is to verify the SSRS settings from SSRS configuration manager, This would include verifying things such as the service account, ports used, connectivity to the SSRS database from SSRS configuration manager, URL reservation, etc.

To further dig into any issues, you can also check the reporting services log files for more information. The default location for these files is <drive>:/Program Files/Microsoft SQL Server/<Instance ID>/Reporting Services/LogFiles but the location may be different in your environment. A good log to check is ReportServerService_<timestamp>.log. It logs all errors and it will provide a complete call stack that should explain why we got an error message.

Additional Information

- Assuming that the report server and report manager URL are working, if a change is required with respect to SSRS (e.g. service account username or password or both) a recommended practice is to take a backup of the current report server and report server tempdb from SQL server as well as A backup of the encryption keys from SSRS configuration manager before making any changes.

- If you use the wizard from Configuration Manager to install your Reporting services point, you can check the progress by looking in sitecomp.log and checking for "rolesetup.exe SMSSRSRP".    Later in the process, you can check srsrpsetup.log and srsspMSI.log to see the install, and then as long as that competes OK, information is passed on to srsrp.log where can see the process of reports being copied over to the reporting database.

- In ConfigMgr 2007 , when you use the Copy Reports Wizard, a log file named ConversionReport.xml containing the results of the copy reports operation is generated in the folder \SMS\AdminUI\AdminUILog on the computer from which you launched the wizard.

Prabhat Joshi | Senior Escalation Engineer | Microsoft

Get the latest System Center news on Facebook and Twitter:

clip_image001 clip_image002

System Center All Up:
System Center – Configuration Manager Support Team blog:
System Center – Data Protection Manager Team blog:
System Center – Orchestrator Support Team blog:
System Center – Operations Manager Team blog:
System Center – Service Manager Team blog:
System Center – Virtual Machine Manager Team blog:

Windows Intune:
WSUS Support Team blog:
The AD RMS blog:

App-V Team blog:
MED-V Team blog:
Server App-V Team blog:

The Forefront Endpoint Protection blog :
The Forefront Identity Manager blog :
The Forefront TMG blog:
The Forefront UAG blog:

Comments (10)
  1. Hi Anonymous, as per scenario mentioned by you, it looks like you need to check permissions for your account using which SCCM console is opened.
    If you are able to see reports using Web manager/ Report manager URL, then they should reflect in the console.
    But since SCCM 2012 has RBAC in it, hence this might be the reason why you are not able to see reports.
    Please see in SCCM console your level of access, try and make yourself a full administrator and then check.
    Regarding the sql version, there have been cases wher db engine is on a different version as compared to reporting engine and that has created issues, but this would not be the case here.

  2. Craig says:

    In step 3 you say re-install Reporting Services. Do you mean the Reporting Services point role in SCCM or the actual instance of Reporting Services on the SQL server?

  3. Craig, in step 3, please re-install Reporting Services point role in SCCM

  4. Anonymous says:

    We have the scenario where no reports show in the Console, however the reports show when accessing the SSRS web ast port 80. Could this be the build of SQL? The installation is as follows:

    No CAS, SCCM 2012 SP1 Primary Server A configured to point to Reporting Services Role installed on Server B
    Database for SSRS installed on C.

    I read some anecdotal info that it might be SQL version, but where should I check the SQL version – A? B? Both?

    1. It’s always advised that database version and reporting services version on sql should be on same build and in past it has been seen that upon bringing them to same level, such issues have been resolved.

      Worth a shot!

    2. please make sure that Database engine and reporting services engine in SQL are on same build, if not make that happen.
      I t has solved many issues in the past

  5. Abdul Rahim says:

    Hi, I have the same issue in my lab. In my case SQL 2008 & SCCM 2012 SP1 is on same server. Initial while installing SQL 2008 I did not select the reporting service, so it was not finding the reporting instance while adding the roll. Now the reporting
    service roll added after installing SQL reporting service, and there were not Database found . I have added Reportserver,ReportservertempDB through reporting service configuration. But Still i am unable to see any reports in the console.

    srsrp.log : Failures reported during periodic health check by the SRS Server ***

    http://server/Reports/Pages/Folder.aspx :- There are no items in Home.

    Please help

    1. Hello Abdul,

      Please check where web URL and report manager URL are working or not in SSRS itself.
      Since SCCM’s reporting services point depends on SSRS, It won’t work unless SSRS doesn’t work itself.
      You can find the URL’s upon open SSRS console.

      If they are working fine, uninstall Reporting services point role from sccm, create a new db in SSRS and then install Reporting services point role in sccm and monitor the logs

  6. Simon says:

    When I add the reporting services point in SCCM from my CAS, the report URL’s do not appear, hence I have no reports. However, I do have these on my primary and I can open reports using internet explorer on my CAS, but not from the console.
    I have a CAS a primary and a SQL server with reporting services installed – pointing at my CAS database.

    Many Thanks

  7. Camilo Pulido Escobar says:

    en mi caso, se soluciono des habilitando el proxy que tenia en mi explorador web

Comments are closed.

Skip to main content