Installing SQL Integration Services after SQL Cluster Setup has Completed


Today I ran into an issue where, SQL Server 2008 SP1 was installed on a Windows 2008 cluster and was working just fine, but we wanted to install SQL Server Integration Services (SSIS) to the two nodes of the cluster. Since SSIS is not cluster aware, we thought it was be just a simple process of adding features to an existing instance of SQL Server. Unfortunately, it was not that intuitive.

In setup’s SQL Server Installation Center you naturally select “New SQL Server stand-alone installation or add features to an existing installation”, because you already have a installed instance of SQL Server on the cluster.

image

In the “Installation Type” step of the setup, if you select the second ratio button to “Add features to an existing instance of SQL Server” is when you run into problems in this situation.

 image

If you select the “Integration Services” option only during the “Feature Selection” step, then proceed with the SSIS installation you will encounter the following error if you already have a clustered SQL instance:

—————————
Rule "Existing clustered or cluster-prepared instance" failed.

The instance selected for installation is already installed and clustered on computer SQLClustInstName. To continue, select a different instance to cluster.
—————————
OK  
—————————

Of course, you don’t want to install another cluster to your instance, but here is the key: you do want to “Perform a new installation of SQL Server 2008”, which is the first radio button in the Installation Type step of the setup (screen shot above). This will allow you to select any feature you desire to put on the system in the Feature Selection step:

image

Here you would only select “Integration Services” (unfortunately my screen shot shows I have SSIS already installed). By just choosing “Integration Services” you can successfully install SSIS on each node of the cluster. You must run this setup on all nodes of the cluster where you want the SSIS service installed.

Note: Don’t forget to alter you <ServerName>.\SQL2008</ServerName> property in the MsDtsSrvr.xml file to correctly point to your SQL virtual server name rather than the default “.\InstanceName” that is currently there.

Have a great day!

Eric Burgess

SQL Server Escalation Services


Comments (10)

  1. SQL Server 2005 and SSIS on a cluster says:

    Can you suggest how to do the same for SQL Server 2005

  2. SQLHopper says:

    Good one bro. I had the same issue and get solved..!

  3. kabloona says:

    Thanks, I just found out I need to do this…..

  4. Fahim (UltimateSQL) says:

    Great help mate. I was stuck in this situation too and tried every other installation option but didn't work. This short blog with screenshots was great help. :)

    Cheers,

  5. amit mathur says:

    how to enable or use sql server intergration services in sql client not a sql server 2008

  6. amit says:

    how to enable sql server integration services in sql client not a sql server 2008

  7. Alex says:

    Thanks, this helped me with installing Sync Framework on a 2008 cluster.

  8. mj says:

    i changed the server name in MsDtsSrvr.xml but still it is not listed in generic resources.

  9. SQLRookie says:

    Thanks…You saved me a ton of time.

  10. JY says:

    THis is really good post. :-)