Hey there,
SSRS itself is not cluster aware. https://learn.microsoft.com/en-us/sql/reporting-services/report-server-sharepoint/high-availability-reporting-services?view=sql-server-ver16
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I need to install Reporting Services on an Always-On cluster with two nodes. Setting up the database is not a problem. I create the database using the listener address and then set up the Always-On availability group for it on the primary and use Automatic Seeding to create and set up the database on the secondary. I don't know how to configure Reporting Services however if the Reporting Services application sits on an Always-On cluster. Is that even possible? When you install Reporting Services should you use the listener address instead of the node name?
Thanks.
Hey there,
SSRS itself is not cluster aware. https://learn.microsoft.com/en-us/sql/reporting-services/report-server-sharepoint/high-availability-reporting-services?view=sql-server-ver16
Hi @Reilly, Todd,
Please read of the documentation.
Reporting Services with Always On Availability Groups (SQL Server)
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
As Dirk wrote, SSRS is not cluster aware.
SSRS is mainly a web server and as with other web server you can setup a web farm = scale-out, see