How to install SQL Server Reporting Service (SSRS) to an existing SQL clustered instance

SYMPTOMS

We all know that SQL Server Reporting Service SSRS is not a cluster aware service, so if we tried to install it on an existing SQL cluster instance we may face the following error during installation:

EXISTING CLUSTERD OR CLUSTER-PREPARED INSTANCE:

RULES “EXISTING CLUSTERD OR CLUSTER-PREPARED INSTANCE” FAILED.

THE INSTANCE SELECTED FOR INSTALLATION IS ALREADY INSTALLED AND CLUSTERD ON COMPUTER “SQL CLUSTER INSTANCE NAME”. TO CONTINUE, SELECT DIFFERENT INSTANCE TO CLUSTER

Solution

We can’t install SSRS on SQL clustered instance through normal installation. Otherwise we will receive the error message above, the solution is to skip the installation rules to install SQL Server Reporting Services in an existing clustered instance. By running the following command:

Setup.exe /SkipRules=StandaloneInstall_HasClusteredOrPreparedInstanceCheck /Action=Install

Now the installation will start without checking rules to install SQL Server Reporting Services in an existing clustered instance, as we can see in the below snapshot:

Now we can see that SQL Server Reporting Service installed successfully:

 

Abduljalil Abolzahab

Advertisements