Open SQL Server Management Studio and connect to the newly installed SQL Server 2017 instance.
In the Object Explorer, right-click on the Integration Services Catalogs node and select Create Catalog.
The Create Catalog window appears. As shown in the following screenshot, check the Enable this server as SSIS scale out master option as well as providing a password for the catalog. Click on OK when finished.
Still in SSMS, run the following SQL statements. The first statement lists the workers available. Copy the WorkerAgentId into the clipboard by right-clicking on the value in the grid and select Copy. Type the second SQL ...
With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.