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.”

    Advertisements
  • Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s