August 6, 2013 at 7:03 am
I have a clustered environment with 3 nodes and 2 instances on it with 1 node always as a passive one.
Customer wants to use one of these instances to configure SSRS now.
How would I install SSRS in this scenario. Customer doesn't want to procure a new license though.
Also, some blogs say that I can install SSRS on all the nodes of the cluster and can use the clustered instance to put the DB on?
In my case, can I install SSRS on all the nodes and map it to 1 DB instance.
Oops..Its very confusing
August 6, 2013 at 7:11 am
Install SSRS on each node, Add the other nodes into ssrs through the scale out deployment tab on each server and initialize it. Without doing it i cant remember the exact screens but its pretty self explanitory when you are going through the process. But yes, they will all point to one database.
August 6, 2013 at 7:22 am
Steveyam90 (8/6/2013)
Install SSRS on each node, Add the other nodes into ssrs through the scale out deployment tab on each server and initialize it. Without doing it i cant remember the exact screens but its pretty self explanitory when you are going through the process. But yes, they will all point to one database.
Is there a way I can fulfil client requirements by not clustering SSRS?
I have heard that clustering SSRS is a complex thing to do.
August 6, 2013 at 8:08 am
Is there a way I can fulfil client requirements by not clustering SSRS?
I have heard that clustering SSRS is a complex thing to do.
You can't really cluster SSRS. It is not a cluster-aware feature of SQL Server. You can cluster the databases used by SSRS and you can cluster an IP for NLB usage, but that does not cluster SSRS itself. The best you can do is as others have stated; install SSRS on the nodes in a scale-out deployment. Then you can use NLB to have an IP resource hit multiple IPs for HA.
Not sure about how that affects licensing though...
Joie Andrew
"Since 1982"
August 6, 2013 at 8:53 am
This is what I have thought to go ahead with:
1. Install SSRS seperately on all 3 nodes of the cluster.
2. Put the databases on one of the instances.
Is there a procedure which helps me do this. This is a critical production instance and I do not want to take any chances
August 6, 2013 at 9:04 am
August 6, 2013 at 12:18 pm
Joie Andrew (8/6/2013)
High Availability (Reporting Services)
Hi,
My SQL Instance is already there on the cluster. i would want to make the SSRS use that instance to create Reportserver database.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply