Fix: SSIS Installation Error – Rule “Existing clustered or clustered-prepared instance” Failed

Posted in: Microsoft SQL Server, Technical Track
ssis installation

 

Problem

You’re trying to install SQL Server Integration Services to an existing SQL Server failover cluster. You chose to add the shared feature to the existing instance and received the error below and couldn’t proceed:

SSIS Install Error: Rule: Cluster Instance Failed

Cause

You are receiving this error because you chose to add the feature on the existing clustered instance. By default, the cluster check will be part of the rules run during pre-checks for the installation.

Solution

Note that SSIS is not a cluster-aware service and doesn’t really fall under the instance. It’s a shared feature. You can simply install it by choosing Add New Instance/Installation  of SQL Server instead of choosing to Add Feature to an Existing Instance. On the feature selection, simply only check SQL Server Integration Services under the shared feature and don’t check the database engine. This will allow you to install the SSIS without any issues.

 

Workaround

As with any rules for the setup, you can bypass the cluster rule by launching the setup from the command prompt with the command below. This will allow you to add the feature on the existing instance. But as I mentioned, it doesn’t really matter since SSIS is a shared feature anyway. I also don’t recommend skipping rules unless you understand what the rule is for, what you’re doing, and whether it’s safe to bypass or not.

 

Setup.exe /SkipRules=StandaloneInstall_HasClusteredOrPreparedInstanceCheck /Action=Install

 

I hope this post useful. Let me know if you have any questions in the comments, and don’t forget to sign up for the next post

 

 

 

email

Author

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

Lead Microsoft Data Platform Consultant
Pio Balistoy is a Microsoft MVP for Data Platform from Singapore. He has been a Database professional for more than 17 years. He brings his passion for SQL to the community by being one of the Community leads for both Philippine Data Platform Forums (formerly Philippine SQL Server User Group) and Singapore SQL PASS.

No comments

Leave a Reply

Your email address will not be published.