question

koredeFranklin-5420 avatar image
0 Votes"
koredeFranklin-5420 asked koredeFranklin-5420 commented

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

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

sql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Zoehui,

Thanks for the answer, i think i was not straight with my question, what i meant in my question is that i have a 2017 sql server environment that does not have Integration services installed on it, now the Developers wants me to install Integration services on this server but when i tried to install Integration services i got an error saying 2017 sql server version does not support adding Integration services because the server has Always on availability group enabled.

What can i do to install the Integration services without messing with the AG.

Thanks.

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @koredeFranklin-5420,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.