SSIS 2016 Access Denied

connectivitypermissionsssis

I followed below steps after SQL Server and Integration Services, but I am still getting an error.

I added SQL service account in Microsoft SQL Server Integration Services 13.0 properties which is under DCOM Config, and granted remote permissions to both service account and dba group account under Launch & Activation Permission & Access Permissions but still getting an error:

connecting to the Integration Services service on the computer SERVER 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.

Windows 2016 Standard and SQL Server 2016 Standard Edition.

Best Answer

Two thoughts come to mind:

  1. You may have missed a step in the configuration setup - Check Eliminating the "Access Is Denied" Error
  2. Is this part of a SQL Server upgrade? If so, you may need to install SSMS for that release. The SSMS 17+ do not support connections to Integration Services on earlier versions of SQL Server. Previous SSMS releases
Related Question