asked
Where do I install SSRS in a SQL 2012 Cluster?
I am trying to determine the best place to install SSRS on my SQL 2012 active/passive cluster. I know SSRS is not cluster aware. If I install SSRS on one of the cluster nodes I will need to install it on the other mode as well. My understanding is the each node in the cluster should be exactly the same. Is it ok to have SSRS install on both nodes but only have SSRS active on one of the nodes? I thought about installing SSRS on a separate server and just use the SQL Instance for the SSRS database but then I would need to license SSRS and I am trying to avoid spending more money. ,
If your comfortable with only one install I'd place it on the passive node.
This site runs by you voting. For each helpful answer below, click on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the thumbs up next to that answer.
As Standard doesn't allow for an SSRS Farm nor is it cluster-aware you have to make allowances when dealing with a cluster. You can install on both nodes but you can only truly configure one of them. If your primary node ever fails and you need SSRS you can configure it at that point and import the encryption keys you'll set up on the original instance into it.
You can install SSRS on both nodes, have the database on the failover instance of SQL. You can then only point to the active node for the SSRS instance. If you run both instances of SSRS active then both the nodes would be licensed. So to answer your question, YES. What you are trying to do can be done and is common practice. To take it a step further, I have known folks to bind an additional IP to the failover instance, create a DNS alias for SSRS and point to the additional IP that way the active SSRS instance follows the SQL Server instance for license reasons.
17 People are following this question.
