If you're seeing this error, or a similar
access denied error you'll need to have your windows account given DCOM permissions. DBAs generally have the ability to add you.
If you're a DBA and want to add a developer to be able to connect to the SSIS services to deploy packages here's a quick punch list:
- Logon to the target SQL Server. Go to Start->Run type lusrmgr.msc
- In the Local Users and Groups dialog box, click Groups->Ditributed COM users
- Once in the Distributed COM users properties dialog box, click Add
- Select the User click OK
- Go back to Start->Run type dcomcnfg
- In the Component Services dialog box, drill down to Component Services->Computers->MyComputer
- Under DCOM Config, right click MsDtsServer, click Properties
- In MsDtsServer100 Properties dialog box, click Security tab
- Under Launch and Activate Permissions, go to Customize->Edit
- Under Launch Permissions click Add
- Under Select Users or Groups, type the user name, click OK
- Under Permissions for the user, Allow or check the checkbox for all 4 (local,remote launch/activation)
- Click OK. Do steps 11-12 for Access Permissions.