Saturday, July 2, 2016

Connecting to the Integration Services - "Access is denied."

If required permissions are not configured for Integration Services for your account, you will experience following error when trying to connect with Integration Services;

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

This clearly indicates that you need permission on it. How can I add required permissions for any account?

Here are the steps for giving required permission;
1. Search for Component Services and open it.
2. Expand Component Services -> Computers -> My Computer -> DCOM Config.

3. Find Microsoft SQL Server Integration Services, right click on it and get Properties. Go to Security tab and add accounts you need with relevant permissions for Launch and Activation Permissions, Access Permissions, and Configuration Permissions by clicking Edit button.

Click OK to save all. You need to restart the Integration Services service for getting added permission applied. Once restarted, you will be able to connect with it without any issue.

No comments: