SQL Server 2022 SSIS Scale Out Configuration From Scratch
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.