SQL Server 2017 Limits Reporting Services Deployment Options

SQL Server 2017, as compared to previous versions, has limited deploying Reporting Services to a single instance per server or VM, potentially blocking some customers from upgrading. Many organizations deploy multiple Reporting Services instances on a single server for load balancing, failover for patching, security controls, and development and testing. The problem with SQL Server 2017 comes from a new Reporting Services installer that is less functional than the previous version.

Become a DOM member or log in to read the full report