SSIS : connection to ssis service failed. access denied

SSIS : connection to ssis service failed. access denied

http://www.sqlservercentral.com/Forums/Topic311706-146-1.aspx

A few things to check:

If you have a firewall between the developer and the sql server:

open a port for SSIS on the firewall (3882 and an additional port for the return traffic)

switch from using a dynamic return port to a static port:

1. hkey_classes_root\appid\{F38B7F09-979B-4241-80D9-2EADED02954F}
   
2. new reg_mutlistring
   
3. Key=Endpoints
   
4. Value=ncacn_ip_tcp,0,port#
   
   (port# is the port you have open on your firewall for SSIS)

Check MsDtsServer in Component Services:

1. add all permissions for msdtsserver for the developer account
   
2. component services > My computer properties > MSDTC > Security Configuration > Network DTC Access > Allow Remote clients
   
3. COM Security > Access permissions > Edit Limits
   
4. add all permissions for msdtsserver for the developer account
   
5. COM Security > Launch and activation permissions > Edit Limits
   
6. add all permissions for msdtsserver for the developer account
   
7. Allow inbound
   
8. allow outbound
   
9. restart MSDTC
   
10. restart SSIS

If this does not fix the problem, make sure you have build 2153:
select @@version
Microsoft SQL Server 2005 - 9.00.2153.00

If you do not have that build, apply SP1 and then the post SP1 rollup in the correct order (apply all six patches in the order listed in the aticle below):

SP1 - http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en
rollup - http://support.microsoft.com/Default.aspx?id=918222

If you still can't connect to SSIS, you need to check other things like DNS and account permissions.

Or - as per the forum thread, try
"The user's Windows account needed to be in the Distributed COM Users group on the server."