SSIS service cannot launch from SSMS

Question

Database server has SSMS version 11.0, and the identified user are able to connect to SSIS from RDP to the database server. But the user cannot access the database server with SSMS version 13.0 as well as 15.0. I have also followed through the doc https://learn.microsoft.com/en-us/sql/integration-services/service/integration-services-service-ssis-service?view=sql-server-2017#manage-the-service and granted access to the Integration Service. But that did not resolve the issue. I have made changes to Microsoft SQL Server Integration Services 13.0 and Microsoft SQL Server Integration Services 11.0 but the user is getting the error:

Answer 1

Hi @Avyayah ,

Please install Integration Services in SQL Server Installation Center.

SQL Server provides a single setup program to install any or all of its components, including Integration Services. Use Setup to install Integration Services with or without other SQL Server components on a single computer.
This article highlights important considerations that you should know before you install Integration Services. Information in this article helps you evaluate your installation options so that your selection results in a successful installation.

Please refer to the following link and pictures:
Install Integration Services (SSIS)

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I hope you are using SSIS SSISDB Catalog.
Starting from the SSIS 2012 onwards there is no need in SSIS service.

Check it out here in the official Microsoft documentation: integration-services-service-ssis-service

Excerpt:

The topics in this section discuss the Integration Services service, a Windows service for managing Integration Services packages. This service is not required to create, save, and run Integration Services packages. SQL Server 2012 (11.x) supports the Integration Services service for backward compatibility with earlier releases of Integration Services.

Starting in SQL Server 2012 (11.x), Integration Services stores objects, settings, and operational data in the SSISDB database for projects that you've deployed to the Integration Services server using the project deployment model.