<div>
Thanks EvilPostIt.<br />
<br />
the load on SSRS is very minimal. Very few reports executed occassinally. <br />
<br />
Does the plan what ever I mentioned sound OK?
</div>


Thanks EvilPostIt.

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

Does the plan what ever I mentioned sound OK?

<div>
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.
</div>


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.

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

</div>
</div>


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,


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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.