Hi,
We are trying to determine how to provide SSRS for high availability since is not cluster aware. We have active/passive SQL Server 2012 cluster with Enterprise Edition where the other node is truly passive so only one active node is licensed. MS recommends scale-out deployment and if I understand well I will need additional servers with SQL Server (standard edition minimum on each) with SSRS installed and use shared database on cluster and use NLB - this is not an option for us.
Is it possible to use only existing SQL cluster nodes and create HA Scale-Out Deployment of SSRS? Are there any possible reason not to go with this? Do we need to license the passive node? I don't need NLB in this case, right?
I found this solution but I am not sure where it will my report request go (on which SSRS) and do I need passive node licensed in the any case as SSRS will run on both nodes (only one SSRS server is handling requests)?
Just as clarification - we need high availability using current sql cluster and not load balancing capability.
Thanks.
We are trying to determine how to provide SSRS for high availability since is not cluster aware. We have active/passive SQL Server 2012 cluster with Enterprise Edition where the other node is truly passive so only one active node is licensed. MS recommends scale-out deployment and if I understand well I will need additional servers with SQL Server (standard edition minimum on each) with SSRS installed and use shared database on cluster and use NLB - this is not an option for us.
Is it possible to use only existing SQL cluster nodes and create HA Scale-Out Deployment of SSRS? Are there any possible reason not to go with this? Do we need to license the passive node? I don't need NLB in this case, right?
I found this solution but I am not sure where it will my report request go (on which SSRS) and do I need passive node licensed in the any case as SSRS will run on both nodes (only one SSRS server is handling requests)?
Just as clarification - we need high availability using current sql cluster and not load balancing capability.
Thanks.