Trying to connect SSIS 2016 can’t be connected from on SQL v17.0 tools. SQL 17 (14.0.17099.0) release of SSMS has known issues that connect to
Integration Services started to face below error.
Error –Description: Connecting to the Integration Services service on the computer
failed with the following error: "Access is denied".
I tried local
installation start SSMS with "Run
as Administrator” Also tried connecting SSIS as “LOCALHOST” when I tried connecting as “LOCALHOST” below is the error I faced.
Error –Description: Connecting to the Integration Services service on the computer "LOCALHOST" failed
with the following error: "The
Specified service doesn’t exist as an installed service”.
Solution: I was
able to connect to SSIS by installing Microsoft
SQL Server Management Studio - 16.5.3 as work around.
This article explains . https://docs.microsoft.com/en-us/sql/integration-services/service/integration-services-service-ssis-service#manage-the-service
