SSRS on a failover cluster
We need to install the webservice and the database on a failover cluster. Our plan was to install the web service on node 1 and the database would naturally be on the cluster aware sql service. We know the RS will not be cluster aware and if node1 bites the dust, reports will be out of business. We were planning to do this tommorow on development, but then found this little tidbit - read the very last paragraph http://www.microsoft.com/dynamics/crm/using/deploy/clusteringssrs.mspx SQL Server Reporting Services failover cluster configurations that are not supported Do not deploy both SQL Server Report Services and the reporting services databases on each node of a multi-node cluster. Moreover, do not deploy SQL Server Reporting Services in a two-node cluster environment that consists of an active node and a passive node where the passive node becomes active during a failover. They don't explain why not to do it - as if it will destroy your machine! This is our main dev cluster and we don't need it to go down. We will not be installing the RS on each node, just one. But I was thinking that if the dns entry for the service points to N1, it will continue to function and make successfull DB calls to the sql server cluster name. Could this work? I've found posts of people installing RS on both nodes and having success - but this would probably require another license...which we don't have. Thanks so much for your help - it is greatly appreciated.
April 10th, 2008 2:22am

bump
Free Windows Admin Tool Kit Click here and download it now
April 10th, 2008 11:20pm

Anyway, the install on one node worked while the cluster was failed over to the second node. My next step is to install it on node two and keep it shut off ready for when N1 goes down, but I need to look into licensing issues for that.
June 20th, 2008 7:38pm

this was useful to me http://www.sqlserverdba.co.cc/2009/01/ssrs-reporting-server-on-cluster.html It explains and clarifies how the Database engine instance must be active on the node you're adding SSRS to. It also explains how to make sure you enter the engine clustered IP/name, not the node. Finally it shows how to enter the reporting server name of the first SSRS node during additional installs so it can properly get access to the shared database.
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2011 2:01pm

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

Other recent topics Other recent topics