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.