DCOM Permissions for SSIS service are Reset after applying a service pack or a cumulative update or a hotfix

On the server, add the user account to the Distributed COM Users group. To do this, follow these steps:

1. Click Start, click Run, type lusrmgr.msc, and then click OK.
2. In the Local Users and Groups dialog box, click Groups, and then double-click Distributed COM Users.
3. In the Distributed COM Users Properties dialog box, clickAdd.
4. In the Select Users dialog box, type the user name underEnter the object names to select, and then click OK two times.

1. Click Start, click Run, type dcomcnfg, and then click OK.
2. In the Component Services dialog box, expand Component Services, expand Computers, and then expand My Computer.
3. Expand DCOM Config, right-click the MsDtsServer object, and then clickProperties.
4. In the MsDtsServer (SQL Server 2005) or MsDtsServer100(SQL server 2008) Properties dialog box, click the Security tab.
5. Under Launch and Activation Permissions, click Customize, and then click Edit.
6. In the Launch Permission dialog box, click Add.
7. In the Select Users or Groups dialog box, type the user name underEnter the object names to select, and then click OK.
8. In the Launch Permission dialog box, click the user name underGroup or user names.
9. Under Permissions for UserName, click to select theAllow check box for the following permissions:
   • Local Launch
   • Remote Launch
   • Local Activation
   • Remote Activation
   Note UserName is a placeholder for the user name that you clicked in step h.
10. Click OK.
11. In the MsDtsServer (SQL Server 2005) or MsDtsServer100(SQL server 2008) Properties dialog box, clickCustomize under Access Permissions, and then clickEdit.
12. In the Access Permission dialog box, click Add.
13. In the Select Users or Groups dialog box, type the user name underEnter the object names to select, and then click OK.
14. In the Access Permission dialog box, click the user name underGroup or user names.
15. Under Permissions for UserName, click to select theAllow check box for the following permissions:
    • Local Access
    • Remote Access
16. Click OK two times.

Workaround 2:

Note: Use this procedure if you are just getting ready to apply the update. For further information about the registry keys discussed in this procedure refer to theMore Information section below

 SQL 2005 Integration Services:

1. At the command prompt, export the security settings for the MsDtsServer DCOM application using the following:
   • regedit /e C:\temp\ssis2005permissions.reg "HKEY_CLASSES_ROOT\AppID\{F38B7F09-979B-4241-80D9-2EADED02954F}"
2. Run the setup program for the service pack or hotfix.
   • Note:This will remove any customization to the MsDtsServer security settings.
3. At the command prompt, import the saved security settings for the MsDtsServer DCOM application using the following:
   • regedit /i C:\temp\ssis2005permissions.reg

 
SQL 2008 Integration Services:

1. At the command prompt, export the security settings for the MsDtsServer DCOM application using the following:
   • regedit /e C:\temp\ssis2008permissions.reg "HKEY_CLASSES_ROOT\AppID\{FAAFC69C-F4ED-4CCA-8849-7B882279EDBE}"
2. Run the setup for the service pack or hotfix.
   • Note:This will remove any customization to the MsDtsServer security settings using the following:
3. At the command prompt, import the saved security settings for the MsDtsServer DCOM application:
   • regedit /i C:\temp\ssis2008permissions.reg