SQL Server Performance Forum – Threads Archive
Adding components to sql 2005 clusterThe basics
SQL 2005 Enterprise
2 node cluster, single instance. So I have had these servers up for a little while and would like to add SSIS to them. I found this document here about running setup from the command line for a clusterhttp://msdn2.microsoft.com/en-gb/library/ms144259.aspx
and this document for installing SSIS from the command line
and this about how to configure SSIS on a cluster.
http://msdn2.microsoft.com/en-gb/library/ms345193.aspx As you can see from this last document, step three seems trivial,
"Install Integration Services on each node of the cluster individually." Can anyone help me put this all together. I think the main thing I need is the command line to install SSIS on a cluster. Chris
May take help of KBAhttp://support.microsoft.com/kb/913967 in this case. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Thank you for your reply, Unfortunately, when SQL is installed in a cluster, it disables the GUI for add/rem components section and only allows you to add/rem nodes. From what I have read at MS, the command line the only way to add/rem components from a cluster. Chris
I had to do the same thing about 6 months and from what I remember correctly, I just installed Integration Services from the sql server 2005 disk on each node.