Microsoft – SQL Server – SSIS Error (The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID {46063B1E-BE4A-4014-8755-5B377CD462FC}

Error Message:

The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID
{46063B1E-BE4A-4014-8755-5B377CD462FC}
to the user LAB\SQLAgt SID (S-1-5-XXXXXXXXXXXX-XXXXXXXXXX-XXXXXXXXXX-XXXX).

 

Diagnostic:

The initial step is to find the problematic component:

  • Launch Regedit
  • Access the branch labelled HKEY_CLASSES_ROOT
  • Right-click and perform a find on the CLS_ID – 46063B1E-BE4A-4014-8755-5B377CD462FC (in this case)
  • Once found, glance to the right panel and there you have it – the problematic component (Microsoft.SqlServer.Dts.Server.DtsServer)

This security permission can be modified using the Component Services administrative tool.

Remediation Steps:

  • Launch Component Services (Using Control Panel\System and Security\Administrative Tools\Component Services)
  • Navigate to Component Services \ Computers \ My Computer \ DCOM Config \ MsDtsServer100 
  • Right click on your selection and from the drop-down menu select “Properties”
  • On the “MSDtsServer100 Properties” window, access the “Security” tab
  • From the “Launch and Activation Permissions” group box select “Customize” .  In the “Launch Permission” window, confirm \ add the Service Accounts (MS SQL Server Agent in this case).  Ensure that the Service Accounts have at minimum “Local Launch” and “Local Activation”
  • From the “Access Permissions” group box select “Customize” .  In the “Access Permission” window, confirm \ add the Service Accounts (MS SQL Server Agent in this case).  Ensure that the Service Accounts have at minimum “Local Access”

References:

6 thoughts on “Microsoft – SQL Server – SSIS Error (The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID {46063B1E-BE4A-4014-8755-5B377CD462FC}

  1. I found everything on your great post here but I don’t know which service account to add. Is there anyway you could help me?

    • Hello:

      Do you know how to determine the Service Account that MS SQL Server Agent is using?

      Here are the steps:

      Using the Services Applet:

      1) Launch the Services Applet (via Administrative Tools \ Services)

      2) Scroll down to “SQL Server Agent (MSSQLServer)” and note down
      the Account listed under “Log On As” column

      Using SQL Server Configuration Manager

      1) Launch “Sql Server Configuration Manager” via “Microsoft SQL Server 2008”
      \ “Configuration Tools ” \ “SQL Server Configuration Manager”

      2) Access “SQL Server Configuration Manager” \ “SQL Server Services” branch

      3) On the right panel the Services are listed

      a) identify the “SQL Server Agent (MSSQLServer)” item and note the “Log on As” Account

      Grant permissions to that account to you may liberally grant access to all domain users.

  2. I wanted to thank you for your help. Your info worked great. Every 7 days at noon I would get the dcom error and now it’s not showing up. Thank you for your help!!!

    • Thanks 4 the feedback. Glad to have been of so little help. The Microsoft SQL Server User Community has done well for all of us. And, so many continue to blog and share knowledge. It is a bit easier to reach out and get some \ more of that help; in sharing a bit myself.

Leave a Reply

Please log in using one of these methods to post your comment:

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