SQL Server Reporting Services- Adding SSRS to SQL Server Clustered Instance

I recently was tasked with a project to consolidate several SQL 2005 database servers down to one existing SQL 2012 database cluster.  While working on this project, I found that one of the database servers needing to be consolidated was utilizing SQL Server Reporting Services (SSRS), but the existing cluster was not configured for Reporting Services.  SSRS is not cluster aware, so adding this feature to an existing clustered instance is not straightforward and will likely lead to a rule check failure on the “Existing clustered or cluster-prepared instance” rule.  Well today is your lucky day, as I’m going to show you exactly how to get beyond this error and on your way to making your SSRS cluster aware!

As mentioned, SSRS is not cluster aware and requires a few extra steps when configuring on a cluster. Trying to add to an existing clustered instance will even add another step.  I’m not going to go into specific details for making SSRS cluster aware but will more so focus on how we can get beyond the “Existing clustered or cluster-prepared instance” rule failure. 

In order to add SSRS to a clustered instance, you will need to run the installation setup on your active node followed by your passive node.  During the setup on both nodes, you will want to choose the ‘Install but do not configure’ option.  After installation on each node, you will need to configure the Report Server URLs and database.  You will find that installing on the active node goes smoothly, but when installing on the passive, you will encounter a roadblock at the rule check step.

Corey_BlogPost6_Pic1.png

You see that 5 rules passed, but 1 failed.  Upon clicking the failed rule check, you will be prompted with details on this failure.

Corey_BlogPost6_Pic2.png

You will also notice this is the end of your road for this installation without getting a success on this rule since the ‘Next’ button is grayed out. 

Sure, you could go back and just create a new instance in the process to install SSRS on this node, but there has to be another way, right?  If only we could skip this rule in the installation….

We can using command prompt!

You simply just open up command prompt on your passive node, navigate to the directory of ‘Setup.exe’ of your installation media, and run the below command:

                 Setup.exe /SkipRules=StandaloneInstall_HasClusteredOrPreparedInstanceCheck /Action=Install

Corey_BlogPost6_Pic3.png

This will launch the installation setup. From here, you step through the installation as you did before, but when you reach the rule check step.

Corey_BlogPost6_Pic4.png

Now you see that the same 5 previous rules passed, and there are no failures.  Issuing the ‘/SkipRules’ in our command prompt command skipped this rule check completely.  This allows clicking ‘Next’ and finishing the installation on the passive node of your cluster, effectively adding SSRS to your existing clustered instance of SQL Server! 

From here, you can continue making your SSRS cluster aware by configuring the Report Server URLs and database on the passive node and then eventually joining them in a scaled-out deployment of SSRS.

Thanks for reading!  If your team needs support for day-to-day database needs, learn more about our SQL Server services.

One thought on “SQL Server Reporting Services- Adding SSRS to SQL Server Clustered Instance”

Leave a Reply

Your email address will not be published. Required fields are marked *