SQL Server Performance

Adding components to sql 2005 cluster

Discussion in 'SQL Server 2005 Clustering' started by HyperSprite, Nov 7, 2006.

  1. HyperSprite New Member

    The basics
    Win2k Enterprise
    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
    http://msdn2.microsoft.com/en-gb/library/ms144291.aspx
    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
  2. satya Moderator

  3. HyperSprite New Member

    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
  4. rklimes New Member

    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.

Share This Page