Access is denied while connecting SSIS

Question

Hello,

While trying to connect SSIS 2019, I am getting below error..

Connecting to the Integration Services service on the computer "localhost" failed with the following error: "Access is denied."

By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.

I have done all DCOM permissions "Launch and Activation Permissions" Access Permissions"

but still i am getting this error.

Please suggest

Answer 1

By default, only administrators have access to the Integration Services service

If you want to use SSMS to connect to SSIS, then you have to start SSMS with "Run as administrator", otherwise you aren't an admin and have no access permissions.

Why do you want to connect to; there is no much to "see"?

Answer 2

@Olaf Helper I am trying through SSMS and Visual studio

i tried with "Run as administrator" but still not able to..

SSIS.JPG

Answer 3

Hi..

i am getting different errors with different version of SSMS v17, v18, v19 and Visual studio

Connecting to the Integration Services service on the computer "localhost" failed with the following error: "The specified service does not exist as an installed service.".

Connecting to the Integration Services service on the computer "localhost" failed with the following error: "Class not registered".

Connecting to the Integration Services service on the computer "localhost" failed with the following error: "Access is denied."

Thanks

bilal

Answer 4

Hi @Bilal H. Bhatt,

The Microsoft SQL Server Integration Services OS Service exists only for backward compatibility with the obsolete SSIS versions 2005 - 2008R2.

Starting from SSIS 2012 onwards there is no need in that OS Service.

Here is an excerpt from the official Microsoft documentation: integration-services-service-ssis-service:

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.

You need to start using SQL Server Integration Services Catalog. Please see below.

Answer 5

Hi @Bilal H. Bhatt,

Please double check that you have installed SSIS service on the machine.

Install Integration Services (SSIS)

Regards，

Zoe Hui

---

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