SSIS Scale-out Manager don´t show status of any Workers

  • Jenda

    SSC Enthusiast

    Points: 113

    Why does my SSIS Scale-out manager on my master server not show the status of any workers?

    My infrastructure is:

    • Master server M1 with Mssql engine (there is SSISDB) SQL2017 EE CU15, SSIS master service,
    • Worker server W1 with SSIS Worker service
    • Worker server W2 with SSIS Worker service.

    I am sysadmin. Certificates are OK. When I run the following query:

    SELECT * FROM [SSISDB].[catalog].[worker_agents]

    on master, all workers are Enabled and LastOnline Time is actual.

    However, "Manage Scale Out.." in SSMS (SSIS Scale-out Manager) v17.9.1 -> there is status of any Workers grey, on Worker Manager page is only grey button "Offline", state of node is grey too. When I try to execute packages on the worker, it works.

    Is it local permissions issue?




  • Site Owners

    SSC Guru

    Points: 80380

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply