Solved

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

Posted on 2011-02-18
3
783 Views
Last Modified: 2012-05-11
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,
0
Comment
Question by:rocky_lotus_newbie
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 34926274
I would install it on both and create a scale out deployment.

http://technet.microsoft.com/en-us/library/ms156453.aspx
0
 
LVL 4

Author Comment

by:rocky_lotus_newbie
ID: 34926482
Thanks EvilPostIt.

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

Does the plan what ever I mentioned sound OK?
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34926707
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

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now