As I thought about this some more last night, why is is that Microsoft allows us to set up a small 'cluster' of SQL severs with the standard edition to be able to handle business data continuity in an active / passive mode to be able to handle hardware failures, etc.; but there doesn't appear to be a way to at least set up a maximum of a two box scale out from SQL Standard edition to allow us to set up the SQL Reporting Services for business data continuity to ensure that hardware failures won't affect our delivery of reporting to critical systems(don't confuse this with the ability to scale out to many more front end systems to handle large volumes)? Maybe there are some registry settings that I am unaware of that would let us set up just the two machines for this purpose? Thanks!

We are currently running SQL 2008 R2 Standard in an active / passive cluster (our SQL is CPU licensed). We would like to run SQL Reporting services from two front end machines (connected to the clustered database) that can be used to connect from c# applications to the: http://<<servername>>/ReportServer/ReportExecution2005.asmx http://<<servername>>/ReportServer/ReportService2005.asmx services on them and then load balance these so that if one drops, our automated batch reporting processes will not be affected. The cost of SQL server enterprise is not feasible with our business / volume but we would like to create the redundancy in this reporting server if we can (we don't have the volume to 'scale out for volume' - but want to ensure business continuity for what processing we do have); so is it possible for us to do what I am looking to do somehow with the SQL 2008 R2 Standard edition CPU license that we have? How else could we enforce this kind of redundancy in our reporting processes? Thanks!

Hi BD1512, Please take the following articles as a reference, and then check if they could help you. Building a Scale-Out SQL Server 2008 R2 Reporting Services Farm using Windows Network Load Balancing Part 1: http://www.mssqltips.com/tip.asp?tip=2335 Building a Scale-Out SQL Server 2008 R2 Reporting Services Farm using Windows Network Load Balancing Part 2: http://www.mssqltips.com/tip.asp?tip=2336 Please feel free to correct me if my understanding is wrong. Thanks, Eileen