question

sac176 avatar image
sac176 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. ,
ssrssql-server-2012cluster
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Are you using Standard or Enterprise?
0 Likes 0 ·
Standard Edition
0 Likes 0 ·
If your comfortable with only one install I'd place it on the passive node.
0 Likes 0 ·
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.
0 Likes 0 ·
Blackhawk-17 avatar image
Blackhawk-17 answered
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.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Blackhawk! We don't need to have SSRS in a failover situation. Can I install SSRS on just the main active node? Or is it better to install it on both nodes so that the nodes are the same?
0 Likes 0 ·
Tim avatar image
Tim answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.