Installing SSRS on one node (as Stand Alone) in a Failover Cluster

Hi Experts,

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,
LVL 4
rocky_lotus_newbieAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
EvilPostItConnect With a Mentor Commented:
I would install it on both and create a scale out deployment.

http://technet.microsoft.com/en-us/library/ms156453.aspx
0
 
rocky_lotus_newbieAuthor Commented:
Thanks EvilPostIt.

the load on SSRS is very minimal. Very few reports executed occassinally.

Does the plan what ever I mentioned sound OK?
0
 
EvilPostItCommented:
I wasnt suggesting the it from a load perspective, more from an HA perspective. But yes you can also do it the way you have suggested.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.