Access denied SSIS

Question

Hi,

While i am trying to access SSIS through Visual Studio, i am getting below error

*connecting to the integration services service on computer "abcdef" failed with following error :"Access denied".

I gave the permission in the DCOM but still getting the same error..

Please help

Answer 1

Hi @Bilal H. Bhatt,

There is no need to connect to that Integration Services OS service. Because that service is obsolete.

I already answered that question on this very Q&A forum few times in the past.

For example: https://learn.microsoft.com/en-us/answers/questions/707658/connection-from-ssms-to-ssis-fails-with-the-specif

UPDATE

The screen shot in your question shows that you are trying to connect to Integration Services service...

In any case, SSIS has two principal environments:

• Development environment, on a developer workstation. Visual Studio, local SSIS project with SSIS packages files on the local file system.
• Run-time environment, on a server with SQL Server instance and SSIS components. SSIS project is housed in Integration Services Catalog inside SSISDB database.
• There is a deployment process that deploys SSIS project from a developer machine to a run-time SSIS server. The best way to do it is to add user AD account to ssis-admin role on SSIS run-time server.

The bottom line, it is impossible to access SSIS packages on a server from Visual Studio on a developer machine.

Answer 2

Have you read this part "... must be runing with administrative privilegs ..." of the error message

You have to start SSMS/VS with "Run as admin".