I am running two instances of SQL 2005 on a two node cluster. Node A handles primarily handles the first instance, and node B handles the other. I installed Integration Services with each instance, and the service will not start on either node. I tried to use the clustering documentation in this thread, but that doesn't seem to work either. Any ideas Let me know if more information is needed.
You abstract the server away from the hardware, and allow it to move between cluster nodes. If you perceive hardware failure as a big risk then you may want to consier it. There are no performance benefits or anything like that to be had. SSIS is not actually cluster aware, but most services can be configured through the Generic Service. For information, there are some guidelines on how to setup SSIS on a cluster here-
SSIS on a cluster
metro16327
I am running two instances of SQL 2005 on a two node cluster. Node A handles primarily handles the first instance, and node B handles the other. I installed Integration Services with each instance, and the service will not start on either node. I tried to use the clustering documentation in this thread, but that doesn't seem to work either. Any ideas Let me know if more information is needed.
Titi des bois
You abstract the server away from the hardware, and allow it to move between cluster nodes. If you perceive hardware failure as a big risk then you may want to consier it. There are no performance benefits or anything like that to be had. SSIS is not actually cluster aware, but most services can be configured through the Generic Service. For information, there are some guidelines on how to setup SSIS on a cluster here-
http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx
qmshou
This might help.
http://sqljunkies.com/WebLog/knight_reign/archive/2005/06/08/15765.aspx
K
Todd Follansbee
Here is the BOL topic on configuring SSIS on a cluster
http://msdn2.microsoft.com/en-us/library/ms345193.aspx