question

ritmo2k avatar image
0 Votes"
ritmo2k asked Jason-MSFT answered

Installing reporting service role

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

mem-cm-generalmem-cm-site-deployment
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Garth avatar image
0 Votes"
Garth answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ritmo2k avatar image
0 Votes"
ritmo2k answered ritmo2k commented

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?


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Where do you see the iis requirement? As far as i know it is not a requirement.

0 Votes 0 ·

Ah, my mistake, I have now read that IIS was separated from SSRS a while ago and it uses HTTP.sys instead.

0 Votes 0 ·
ritmo2k avatar image
0 Votes"
ritmo2k answered

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Garth avatar image
0 Votes"
Garth answered ritmo2k commented

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

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I can access the reporting server from a web browser on the config manager server.

I imagine this is a permission issue, I am just not clear what needs permissions granted where...

0 Votes 0 ·

Did you open the firewall ports to SSRS and WMI?

0 Votes 0 ·
ritmo2k avatar image ritmo2k GarthJones-9654 ·

I had exceptions for tcp 80 and 443, however I added a temporary exception for all ports just to test.

Based on some searching, it looks like the reporting services role must be installed on the same host that has SSRS installed. In my case, that would be the database server which is not what I was hoping for.

0 Votes 0 ·
Show more comments
Jason-MSFT avatar image
1 Vote"
Jason-MSFT answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.