HELLO! Please i have an issue with installing integration services on an instance with 2017 version that has Always on High Availability group.

Question

How to add integration to an existing instance which has Always on high availability group enabled on it

Answer 1

Hi @korede D Adumati ,

In order to provide the high-availability for the SSIS catalog (SSISDB) and its contents (projects, packages, execution logs, etc.), you can add the SSISDB database (just the same as any other user database) to an Always On Availability Group.

Prerequisites
Do the following prerequisite steps before enabling Always On support for the SSISDB database.

1.Set up a Windows failover cluster. See Installing the Failover Cluster Feature and Tools for Windows Server 2012 blog post for instructions. Install the feature and tools on all cluster nodes.

2.Install SQL Server with Integration Services (SSIS) feature on each node of the cluster.

install-integration-services
install-ssis

3.Enable Always On Availability Groups for each SQL Server instance. See Enable Always On Availability Groups for details.

Also take a reference here: ssis-catalog

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.