SSRS is missing after failover to other node

Posted on

Question :

We have 2 node setup cluster, after a failover I can’t see the reporting services, even the service it self is missing.

I checked control panel program manager, SSRS is not installed, I open reporting service configuration manager when clicking Find, it can’t find the server. Is there a way to retrieve that.

There are active reports already running before the failover.

Sorry I’m new in SSRS, I researched the web and can’t find any solution.

Answer :

Reporting services is not cluster-aware. If you want high-availability you need to set up a scale-out deployment where multiple Report servers share the same back-end database.

From the documentation: High availability in SQL Server Reporting Services

A scale-out deployment provides a way to share a database. If one
report server goes down, other servers in the same deployment will
continue to work.

Reporting Services is not cluster-aware. By itself, a scale-out
deployment does not provide load balancing

So you would have needed to install SSRS on more than one machine and set it up like that before the failover happened.

Leave a Reply

Your email address will not be published. Required fields are marked *