SSIS Scale out 2017 - Worker , requires SQL Instance? RRS feed

  • Question

  • Planning to have an Master and two workers. Master since it has SSIS DB we will need to have to SQL Instance for it, does workers machines require dedicated SQL Instance for it or installation of workers service / component is sufficient? 

    How does the licensing model work ?

    Thursday, December 21, 2017 4:35 PM

All replies

  • Hi Vikrenth,

    I am tempted to say yes, but I stongly suggest you inquire with your software vendor or licensing authority and let us know what was the outcome.




    Thursday, December 21, 2017 7:51 PM
  • Hi Vikrenth_R,

    Adding to other post, you can review this article about how to install scale out workers.

    And regarding to the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the Guide to Worldwide Microsoft Licensing Sites to find contact information in your locations.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, December 28, 2017 6:26 AM
  • Vikrenth_R,

    The direct answer to your question is the worker service talks back to the SSISDB on the SQL Instance on the Master SSIS server.  So, no the Worker SSIS server does not need a separate instance of SQL server installed on it.

    Licensing can generally only be answered on an individual basis.  I agree with Lydia below, and call Microsoft directly.

    Paul LaGrone

    Paul LaGrone

    Wednesday, May 30, 2018 1:18 AM