0

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.

1

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
  • Thanks Derek. I uninstalled SSMS17+ and installed SSMS 16.5 version which works fine. – Sandeep Oct 25 '17 at 20:36
  • That's great, Sandeep! Please upvote my answer as the resolution to your question. – Derek B. Bell Oct 26 '17 at 14:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.