Hi, I have 3 physical servers and a SAN on which to install SQL 2008 SP2 and windows 2008 R2. It requires clustering and all Instance Features installed including SSRS. Having read a few forum posts, I'm now not sure how I should set up the SSRS on this. Should I cluster node 1 and 2, install the instance features on them and do the active/passive on just them. Then install just SSRS on node 3 and point it to the databases on the SAN that was created when I installed Node 1 and 2. node 3 now won't be load balanced or participate in failover but I've only 3 physical boxes, 3 windows ent licenses and 4 SQL ent licenses to play with. Any help or guidance would be appreciated. Paul C

Just to add you can use a F5 or a NLB load balancer to achieve load balancing.

Hi Paul, Firstly, Reporting Services is not cluster-aware. The best way to ensure the availability of Reporting Services functionality is to do the following: Use the high availability features of the SQL Server Database Engine to maximize the uptime of the report server databases. If you configure a Database Engine instance to run in a failover cluster, you can select that instance when you create a report server database. Configure multiple report servers to run in a scale-out deployment, where all the servers share a single report server database. Deploying multiple report server instances, preferably on different servers, in a scale-out deployment can help provide uninterrupted service in the event one of the report server instances goes down. A scale-out deployment provides a way to share a database. If one report server goes down, other servers in the same deployment will continue to work. Reporting Services is not cluster-aware. By itself, a scale-out deployment does not provide load balancing; it does not detect the processing loads on a report server and route new processing requests to the least busy server. It does not re-route processing requests that failed before completion. To get load balancing features, you must configure load balancing for the Web servers that host the report servers, and then configure the report servers in a scale-out deployment so that they share the same report server database. The Report Server Web service and Windows service are tightly integrated and run together as a single report server instance. You cannot configure availability for one service separately from the other. See http://technet.microsoft.com/en-us/library/ms159114.aspx on how to configure a report server scale-out deployment. thanks, Jerry

Hi Vikram, Could you please share with me how to configure F5 for SSRS? Cheers, Uzzie