November 15, 2009 at 6:06 pm
I've built a SQL 2008 Cluster but SSRS only installed on the first node. When I added the 2nd node it didn't install SSRS on this node AND I didn't see an option to add SSRS to the build at this time. Now the cluster is built there seems to be no way of adding SSRS to the 2nd node except as a named instance.
Does anyone know of a way of adding SSRS to an existing node? If not what are the implications of adding it by installing it as another instance?
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
February 21, 2010 at 4:12 am
Leo,
Yyou need to install SSRS 2008 on each node seperately and configure them with the Instance which is clustered. For example, If you have two nodes A and B and the Cluster name is CLU and the instance name is CLUINST, you need to install SSRS on both the nodes A and B seperately and you need to Configure the SSRS with the Reportserver database created in CLU\CLUINST instance.
If you have SQL 2008 enterprise edition, then only you can share the Reprot Server Database between Node A and Node B. Sharing can be done using Scale-Out deployment option in SSRS 2008 Configuration
To Configure Scale out deployment for SSRS
February 21, 2010 at 10:11 pm
Leo.Miller (11/15/2009)
I've built a SQL 2008 Cluster but SSRS only installed on the first node. When I added the 2nd node it didn't install SSRS on this node AND I didn't see an option to add SSRS to the build at this time. Now the cluster is built there seems to be no way of adding SSRS to the 2nd node except as a named instance.Does anyone know of a way of adding SSRS to an existing node? If not what are the implications of adding it by installing it as another instance?
Leo
First thing SSRS is not cluster aware. Best practices are not to install SSRS on same cluster nodes as SQL servers database engine running on, why don't you install SSRS on virtual servers. If you are anticipating high reports activity then deploy them in scaleout deployment. Install SSRS on two virtuals and load balance them using Microsoft NLB. However you must already know you can configure database hosted on cluster services for SSRS.
EnjoY!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply