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

Advertisement

One thought on “How to install SQL Server Reporting Service (SSRS) to an existing SQL clustered instance

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s