February 12, 2015 at 5:31 am
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 on this case, right?
I found this solution http://www.tfsconsulting.com.au/how-to-configure-high-availability-sql-reporting-service-scale-out-deployment-clustering/ 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.
February 12, 2015 at 5:59 am
midejan (2/12/2015)
Hi,We are trying to determine how to provide SSRS for high availability since is not cluster aware.
Putting it into a highly available web farm is the way to go
midejan (2/12/2015)
MS recommends scale-out deployment and if I understand well I will need additional servers with SQL Server (standard edition minimum on each)
No, for scaled out SSRS deployments in web farms you require Enterprise or Business Intelligence edition
midejan (2/12/2015)
and use NLB - this is not an option for us.
That is your only option, what were you hoping to implement?
midejan (2/12/2015)
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 on this case, right?I found this solution http://www.tfsconsulting.com.au/how-to-configure-high-availability-sql-reporting-service-scale-out-deployment-clustering/ 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)?
Hmm, great article recommending that you bypass the installer checks to add features to an instance. Not sure MS would support you if you ever needed it.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2015 at 6:17 am
So what does "highly available web farm exactly means": in addition to the existing sql cluster i need 2 or more servers with SQL Server Enterprise Edition, right? Which is unbelievable by MS as we will need to spent more money.
So this means that SQL Server Reporting Services failover cluster configurations is not supported my MS, but my question is if it is possible and do I need to license the passive node if I go to some unsupported configuration on cluster?
Thanks
February 12, 2015 at 7:03 am
ApolloDB (2/12/2015)
So what does "highly available web farm exactly means": in addition to the existing sql cluster i need 2 or more servers with SQL Server Enterprise Edition, right?
Exactly that. The SSRS instances are installed to a load balanced web farm and utilise a single database which may be stored on your existing SQL Server FCI.
ApolloDB (2/12/2015)
Which is unbelievable by MS as we will need to spent more money.
Did you expect it for free?
ApolloDB (2/12/2015)
So this means that SQL Server Reporting Services failover cluster configurations is not supported my MS, but my question is if it is possible and do I need to license the passive node if I go to some unsupported configuration on cluster?Thanks
Don't know, have never implemented the scenario shown in that link and not sure I'd want to. When a scaled out farm has been called for, it's been done using a highly available web farm.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply