Accessing SSIS gets an "access is denied" error

Access SSIS get "Access is denied "Error

Problem Description:

SQL Server SP1 (x64) on Windows Server R2 SP1 (x64) performs the following actions:

1. Open SSMs and select "Connect", "Integration Services ...".
650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image002 "src=" http://s3.51cto.com/wyfs02/M01/6D/1A/wKiom1VcMvLx6sVYAABumJ37hTU827.jpg "border=" 0 "height=" 171 "/ >

2. After entering the instance name, click "Connect".
650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image004 "src=" http://s3.51cto.com/wyfs02/M02/6D/15/wKioL1VcNG3TPXH3AADk97kJ4l4083.jpg "border=" 0 "height=" 324 "/ >

3. Get an "Access is denied" error.
650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image006 "src=" http://s3.51cto.com/wyfs02/M00/6D/15/wKioL1VcNG6AIMiKAAGPxoD4jsw248.jpg "border=" 0 "height=" 317 "/ >

When a user who does not have sufficient permissions tries to connect to an Integration Services instance on a remote server, the server responds with an "Access is denied" error message. Ensure that the user has the required DCOM permissions to avoid this error message.

Workaround:

To grant the Integration Services service permissions, proceed as follows:

1. If the user is not a member of the local Administrators group, add the user to the distributed COM Users group. With "Start", "Administrative Tools", "Computer Management" pop Up the Computer Management window, expand "Local Users and Groups", "Groups", double-click "Distributed COM users to add the user to the group.
650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image008 "src=" http://s3.51cto.com/wyfs02/M02/6D/1A/wKiom1VcMvXy22IqAAG0-o2goRg388.jpg "border=" 0 "height=" 447 "/ >

2. Navigate to "Start", "Administrative Tools", "Component services", and eject the Component Services window.

3. Expand Component Services, Computers, My computer, and then click the DCOM Config node.
650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image010 "src=" http://s3.51cto.com/wyfs02/M00/6D/1A/wKiom1VcMvWCn_DRAAC_wDSuWIs810.jpg "border=" 0 "height=" 210 "/ >

4. Select the DCOM Config node, and then select Microsoft SQL Server integration Services 12.0 in the list of applications that you can configure.
650) this.width=650; "title=" clip_image012 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image012 "src=" http://s3.51cto.com/wyfs02/M01/6D/15/wKioL1VcNHCiS2wAAABOkQuecc0066.jpg "border=" 0 "height=" 51 "/ >

5. Right-click "Microsoft SQL Server Integration Services 12.0" and select "Properties".

6. In the Properties dialog box, select the "Security" tab.
650) this.width=650; "title=" clip_image014 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image014 "src=" http://s3.51cto.com/wyfs02/M01/6D/1A/wKiom1VcMveDZ-MxAAFAahWAx8Q928.jpg "border=" 0 "height=" 534 "/ >

7. Under Access Permissions, select Customize, and then click Edit ... to open the Access Permission dialog box.

8. In the Access Permission dialog box, click Add ... or Remove and assign the appropriate permissions to the applicable users and groups. The available permissions are "Local access", "Remote access". Access permissions can grant or deny permissions for local or remote access.
650) this.width=650; "title=" clip_image016 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image016 "src=" http://s3.51cto.com/wyfs02/M02/6D/15/wKioL1VcNHLShSnjAAEE5k_F1Gs374.jpg "border=" 0 "height=" 446 "/ >

9. Click OK to close the dialog box.

10. Close the MMC snap-in.

11. Restart the Integration Services service.

12. Re-link the Integration Services service via SSMS.
650) this.width=650; "title=" clip_image018 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "alt=" clip_image018 "src=" Http://s3.51cto.com/wyfs02/M02/6D/15/wKioL1VcNHLBp3qEAAB1OL_ide8233.jpg "border=" 0 "height="/>

This article is from the SQL Server deep dives blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1653165

Accessing SSIS gets an "access is denied" error