Share via

Problem with open SSIS folder by SSMS on clustered node

UrBel 140 Reputation points
2024-09-27T10:12:45.47+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,575 questions
Accepted answer
  1. ZoeHui-MSFT 36,511 Reputation points
    2024-09-29T02:27:18.4266667+00:00

    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.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.