SSRS reporting services on multiple node

Question

Hi All,

I have two SQL Server node joined with AG on high availability. And one of the Node SSRS services are configured. As expected when we are fail over to another SQL node it report services are stop working.

So my question is how we can configure it with SQL Server failover automatic move SSRS instance to another server. I have SQL Server 2017.

Can I use same SQL server for high availability of SSRS reports?

As per my understanding I have to configure SSRS on another server also and from scale out panel of SSRS. After this configuration can SSRS understand which server is running and connect to available SQL Server node.

What is the best and recommended way to use SSRS on high availability ? Is it required to make separate sql server and ssrs service instance ?

Answer 1

SSRS is not a cluster-aware service, but you can create a scale-out farm for HA, see High availability in SQL Server Reporting Services

Answer 2

Hi @AlexRobert ,
As part of the SQL Server Always On offering, Always On Failover Cluster Instances leverages Windows Server Failover Clustering (WSFC) functionality to provide local high availability through redundancy at the server-instance level-a failover cluster instance (FCI).
You can see: Always On Failover Cluster Instances (SQL Server)
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

SSRS should be on all nodes. Unstead of using the computer name in the ssrs url use the cluster name. Then you will be pointing to the active node.