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?