SQL Server 2022 SSIS Scale Out Configuration From Scratch

Опубликовано: 12 Май 2023
на канале: MS SQL DBA Tech Support
972
10

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.


Смотрите видео SQL Server 2022 SSIS Scale Out Configuration From Scratch онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MS SQL DBA Tech Support 12 Май 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 972 раз и оно понравилось 10 людям.