Reports tab not displaying any reports in MEM

Gary Hicks 1 Reputation point
2022-07-19T19:11:26.163+00:00

I have recently set up a new MEM site. Both the site server and sql are hosted on the same server. I have installed sql reporting services with sql server and the reporting services point in MEM. For some reason the reports tab does not display anything in the console. 222400-reports-blank.png There are some error messages in component monitoring.222481-reporting-point-component-status.png
One of the messages states that sql reporting services is not running, however, I checked and verified that it is running.
222390-services.png

The reports do display in the web browser, although currently we do not have a web certificate installed.222491-web-service-url.png
222443-web-portal-url.png222462-report-server-http-link.png
Any recommendations would be appreciated.

222463-srssetuplog.png

Microsoft Configuration Manager
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Garth 5,801 Reputation points
    2022-07-20T01:16:54.307+00:00

    Are the console remote to ssrs? Is the firewall port 80 open? Can you browser to Ssrs from remote server?

    1 person found this answer helpful.
    0 comments
  2. Gary Hicks 1 Reputation point
    2022-07-20T20:01:45.197+00:00

    Yes, I am connecting from a remote console. Although, I have the same issue using the console on the site server. I confirmed ports 80 and 443 are open. I am to browse to the web addresses from a remote server.

    0 comments
  3. Amandayou-MSFT 11,041 Reputation points
    2022-07-21T03:30:25.337+00:00

    Hi,

    Based on that there is no issue in the log, we may try the steps:

    1. Uninstall Report Services
    2. Reboot Server
    3. Reinstall Report Services
    4. Configure Report Services
    5. Reinstall the Report Service Role in ConfigMgr

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  4. Gary Hicks 1 Reputation point
    2022-07-21T15:30:06.603+00:00

    I was reviewing the Microsoft instructions for setting up the reporting services point. They mention about the account that runs Reporting Services being a member of the "Windows Authorization Access Group". Have you ever heard of this. This is currently not configured. I have not seen this mentioned in anyone's blog, but, it is part of the Microsoft Installation instructions.
    223204-reporting-services-installation-config.png

    Another question is Microsoft "Report Viewer" required to be installed on the site server? I do not have this installed.

    0 comments
  5. Garth 5,801 Reputation points
    2022-07-21T17:00:03.603+00:00

    Yes that is true but that the execution account need access to Windows Authorization Access Group sec group. but this will NOT your problem listed above.

    By chance did you have an old SSRS site that not longer exist?

    BTW Here is a bit more about Windows Authorization Access Group
    https://www.recastsoftware.com/resources/windows-authorization-access-group-ssrs-and-sccm/

    0 comments