Installing SSIS on a SQL Server Failover Cluster Instance

Installing SSIS on a SQL Server Failover Cluster Instance

by

This short post, discusses about installing SSIS on a SQL Server Failover Cluster Instance and how you can resolve the error message:

The instance selected for installation is already installed and clustered
on computer [ComputerName]. To continue, select a different instance to cluster.

 

Reproducing the Error Message

If you have already deployed a SQL Server Instance on Windows Failover Cluster and you want to add SQL Server Integration Services (SSIS) on that cluster, if you try to do this via the installation option  “Add features to an existing instance of SQL Server …” then you will get the below error message:

Rule “Existing clustered or cluster-prepared instance” failed.

The instance selected for installation is already installed and clustered on computer [ComputerName]. To continue, select a different instance to cluster.

 

Why You Get the Error Message?

Getting the above error message is absolutely normal. The reason is that SSIS does not provide native support for Windows Failover Clustering, therefore,  you get the above error message.

 

How to Properly Install SSIS on a SQL Server Failover Cluster Instance

As explained above, SQL Server Integration Services (SSIS) do not provide native support for Windows Failover Clustering. Therefore, you cannot add it as a feature on an existing SQL Server Failover Cluster.

However, what you can do, is to individually install it on each node that participates to the Windows Failover Cluster.

Therefore, instead of selecting the option “Add features to an existing instance of SQL Server …”, you should do the following on each node that participates to the Failover Cluster:

  1. Start the SQL Server Installation Center
  2. Select “Perform a new installation of SQL Server ..“
  3. In the list of features, select only “Integration Services“
  4. Re-Patch the node with the same service pack/cumulative update used for patching the SQL Server instance.

After performing the above, you will end up having SQL Server Integration Services (SSIS) running on all nodes of the failover cluster.

 

Using SQL Server Integration Services on a Failover Cluster

Further using SSIS on the failover cluster, involves programmatically and procedurally taking into consideration, that the SQL Server instance is clustered.

 

Strengthen your SQL Server Administration Skills – Enroll to our Online Course!

Check our online course on Udemy titled “Essential SQL Server Administration Tips”
(special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Learn More

Featured Online Courses:

 

Related SQL Server Administration Articles:

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub

Views: 7,074