Home Forums SQL Server 2008 SQL Server 2008 Administration Adding Integration Services to clustered nodes RE: Adding Integration Services to clustered nodes

  • October 31, 2011 at 9:41 am

    #1401150

    MysteryJimbo (10/28/2011)

    I don't install SSIS on clusters as its not recommended and isnt cluster aware. Have you read this article?

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

    Thanks for your help. SQLArcher is correct - Installing SSIS on a clustered node does not necessarily make it a clustered service. A clustered service fails over between nodes. What I have done is installed SSIS as a service on each node of the cluster, without failover. See the third paragraph of the MSDN article. It just means that SSIS is available on every node of the cluster, which is why it is preferable that it can be reached by cluster name, not just node name.

    SQLArcher - thanks for your advice. I was working on just the active node's configuration. I'll try updating both nodes and restarting the service this afternoon and see what that does.