Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-02-18
3
Medium Priority
?
791 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

670 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