June 16, 2015 at 2:29 am
Hi all
Can anyone tell me if it is supported to install Reporting Services on both the active and passive nodes in an SQL Server Failover Cluster and use the non-active node as a warm standby?
We have relatively simple reporting requirements so the idea would be that if Node 1 went down, we could just repoint our users are Node 2 temporarily.
Both reporting services instances would be configured to target the same SSRS database running on the SQL Cluster
Many thanks
S
June 16, 2015 at 4:05 am
simon.harvey 41170 (6/16/2015)
Can anyone tell me if it is supported to install Reporting Services on both the active and passive nodes in an SQL Server Failover Cluster and use the non-active node as a warm standby?
You can install SSRS on cluster nodes, the supported route is to perform a new standalone install using a new instance name, detailed here
simon.harvey 41170 (6/16/2015)
Both reporting services instances would be configured to target the same SSRS database running on the SQL ClusterMany thanks
S
You'll need enterprise edition to achieve scaled out SSRS capability
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 16, 2015 at 5:54 am
Hi Perry
Thanks for the reply and advice
I've installed Reporting services as two additional instances on the nodes and connected them together in a scale out setup. They are both configured to use the same report database and all is working well. They serve reports quite happily off of their respective node addresses, e.g. http://node1/Reports and http://node2/Reports
In order to get a bit closer to a true HA setup I think I need to get NLB running on both nodes now. Although I've configured SQL Clusters and NLB independently of one another a few times now, I've never needed to install NLB on an SQL Server Failover setup
Do you happen to know if that is a supported config? SQL Server Failover Cluster + NLB for the reporting server instances?
Thanks again for your help
S
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply