SSRS, high availability on Standard edition cluster
I know this isn't supported out of the box for Standard edition, but my customer isn't about to pay for Enterprise plus 2 new servers for a proper scale-out deployment, so.... We have a 2 node, single instance cluster with reporting services installed on each node (during initial install on Node A, after the fact on Node B). This of course results in RS having 2 instance names, one for each node. When we get a failover, the customer has to adjust his application to point to the RS instance on Node B. I have no idea how that is all set up. Looking for any way that will reliably allow the application to continue to serve up reports to the web users after the failover is complete and the DB is back online. Found this article but don't have proper lab to test with: http://brodaric.blogspot.com/2011/04/installing-sql-server-2008-r2-reporting.html?showComment=1326480076732#c8627229074017736561 All input is appreciated! Kevin3NF
January 13th, 2012 3:09pm

Hello Kevin3NF, Here is an msdn blog that discusses a similar issue: http://blogs.msdn.com/b/lukaszp/archive/2009/10/28/high-availability-frequently-asked-questions-about-failover-clustering-and-reporting-services.aspx Thanks, Swetha G | Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2012 6:17pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics