We have a SQL Server 2008/Windows 2008 R2 Active passive cluster. We need to have SSRS for reporting needs.
Since SSRS is not cluster aware and does not support failover, Can I go ahead and install SSRS on the passive node and choose "New SQL Server Stand Alone Installation" and install just the SSRS Server?
I would like to point this SSRS Databases on the existing Clustered SQL Server.
Please let me know if this plan looks OK.
Thanks in Advance,