Installing reporting service role

ritmo2k 706 Reputation points
2021-10-07T21:11:02.827+00:00

I am adding the reporting services point to a current branch primary server. The primary uses an SQL Server 2019 instance located on a Windows Server 2022 Core host.

What is the convention for this layout, should SQL Reporting Services be installed on the primary server (which already has IIS), or on the database server (which does not seem to be optimal)?

Thanks

Microsoft Configuration Manager
0 comments
Accepted answer
  1. Garth 5,801 Reputation points
    2021-10-07T21:41:54.897+00:00

    SSRS should be install on the SQL box, but I don't know if it is supported on CORE. You CAN install SSRS on primary site but that will cause a double hop (aka slowness, maybe isssue(s), harder to troubleshoot, etc.) aka Primary(SSRS) to SQL server to read SSRS db then back it SSRS server process the RDL then back to SQL to query CM db for the report data then results are returned to SSRS for it to processed and displayed.

    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jason Sandys 31,151 Reputation points Microsoft Employee
    2021-10-08T15:05:29.693+00:00

    One additional note here, SSRS does not require IIS. Also, as I think you've surmised, SSRS itself does not need to be installed on the SQL Server or the primary site server. For many environments, installing it on the same system as SQL is best, but that depends on many variables.

    1 person found this answer helpful.
    0 comments
  2. ritmo2k 706 Reputation points
    2021-10-07T22:02:36.947+00:00

    I can't find a list of prerequisites for the IIS requirements anywhere at install-reporting-services, do you know of a source for that info?

  3. ritmo2k 706 Reputation points
    2021-10-08T10:18:13.187+00:00

    I have ran the SSRS configuration utility on the database server and it appears to have completed successfully, but the reporting services installation on the primary site server cannot find any SSRS instances, any idea what I am missing?

    138873-reporting-services-point-installation.png

    0 comments
  4. Garth 5,801 Reputation points
    2021-10-08T10:45:44.223+00:00

    have you confirm that you can access ssrs from a web browser? Are the firewall ports open?