Problem with open SSIS folder by SSMS on clustered node

Question

Hi Expert,

I'd being installed SSIS service on each clustered nodes, only SQL Server engine that installed as FCI Resource, but I succesfully opened SSIS folder (MSDB folder) by SSMS at only one of nodes NOT both..

if any missed setting or configuration, please help me to solve it...

great thanks & appreciation for all respond & advice

regards,

UrBel

Answer 1

Hi @UrBel，

Clustering Integration Services is not recommended.

To manage your packages on any node in the cluster from any other node in the cluster, modify the configuration file for the Integration Services service on each node in the cluster. You modify each of these configuration files to point to all available instances of SQL Server on which packages are stored. This solution provides the high availability that most customers need, without the potential problems encountered when the Integration Services service is configured as a cluster resource. For more information about how to change the configuration file, see Integration Services Service (SSIS Service).

To configure the Integration Services service as a cluster resource, you need to complete the following tasks as said in the official documentation.

Integration Services (SSIS) in a Cluster

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.