Installing SSIS on Failover Cluster

[w33mhz]

I am needing to install the Integration services on my existing 2005 SQL installation. The installation is setup as a Failover Cluster, so I have to machines that need the installation. I did google it, and I did find a post that was copied to a couple different sites about stoping the cluster services on both nodes then installing. Is this correct?

 

[Ovatvvon]

I am not aware of the need to stop the cluster services yourself to install, although during the installation it may bring the cluster down once or twice.

Also, just an FYI (in case you don't know), Integration Services is NOT cluster aware, so when your cluster fails over to the other node, SSIS will cease to run until it is failed back.

-Ovatvvon :-Q

 

[JayKusch]

Ovatvvon is correct about SSIS not being cluster aware BUT you can be installed on each node of the cluster as a stand-alone app.

You may want to read a bit from this link:

http://msdn.microsoft.com/en-us/library/ms345193.aspx

Thanks

J. Kusch

 

[Ovatvvon]

Jay is correct. I did not mean to give the impression that you cannot install on one side of a cluster. You can.


-Ovatvvon :-Q