Ensure that SSRS is Working while Using Availability Groups


This blog post discusses SSRS in an Always On Availability Group. To make sure I’m staying laser focused on this topic, I need to cover some fundamentals.

SSRS installation (SQL Server 2017 and later)

Starting from SQL Server 2017, Microsoft decided to separate SSRS from a SQL Server installation container (ISO). Keeping the pros and cons of this change aside, that means that Microsoft decided that some customers would not need SSRS and adding a separate step to install it would effectively block an accidental « next-next » type of installation. If a separate SSRS installer is triggered, it will add all