SQL Server 2022 SSIS Scale Out Configuration From Scratch

Published: 12 May 2023
on channel: MS SQL DBA Tech Support

972

Step By Step:
1.In this demo, I am going with Option 1.
•Node 1 as a master.
•Node 2 & Node 3 as workers.

2.Install integration services along with Scale Out Master on Node1

3.Copy the Scale Out Master certificate from Scale Out Master (Node 1) to all worker nodes [Node2 & Node3]
Note: You can find this certificate in the installation directory.
In your case, the installation path may vary:
C:\ProgramFiles\Microsoft SQL Server\160\DTS\Binn\SSISScaleOutMaster.cer

4.Install integration services along with Scale Out worker on Node1 & Node2.

5.Copy the Scale Out worker certificate from both workers (Node2 & Node3) to the master (Node1).

6.Install both worker certificates on the master.

7.Create SSIS DB catalog on the master and select the "Enable this server as scale-out master" option.

8.Select "Manage scale-out" and add workers.

9.Deploy the sample package and run it in scale-out worker mode. Verify the results.
Note:Please enable sa authentication for master node. And also keep same account to avoid issues further.

Watch video SQL Server 2022 SSIS Scale Out Configuration From Scratch online, duration hours minute second in high quality that is uploaded to the channel MS SQL DBA Tech Support 12 May 2023. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 972 times and liked it 10 visitors.

10,484