Why did SSRS move away from IIS?

Rob Ainscough 26 Reputation points
2024-03-19T16:52:37.1333333+00:00

My situation which doesn't have a solution since Microsoft removed IIS and went with internal Http.sys:

I need to enable security via SSL/TLS on my SSRS server. I have 20 web apps that reference SSRS front end using HTTP, since SSRS doesn't use IIS I can't use URL ReWrite module for IIS 10.x. SSRS has no provision for HTTP to HTTPS rewrite.

Since I inherited these 20 web apps, I will have to find and modify all code references that use HTTP and convert them to HTTPS (find and replace will not work in all cases based on how this very old code is written). Next I'll have to schedule downtime for TLS/SSL cert install and setup. Then I'll need to deploy my 20 web apps with updated HTTPS references.

NONE of this would be needed IF Microsoft continued with using IIS for SSRS. So why on earth did Microsoft end that functionality?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,796 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 32,506 Reputation points
    2024-03-20T05:57:54.0466667+00:00

    Hi @Rob Ainscough,

    You can install and run SQL Server Reporting Services (SSRS) and Internet Information Services (IIS) on the same computer. The version of IIS that you're using determines the interoperability issues you must address.

    Details you may check Install Reporting and Internet Information Services side-by-side

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments