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

• Jenda

  SSC Enthusiast

  Points: 174

  More actions

  July 16, 2019 at 8:49 am

  #3663320

  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: 80320

  More actions

  July 17, 2019 at 9:10 am

  #3663687

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

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