How to resolve "A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal""

Question

Integration Services Catalog was just created and we are trying to deploy a project to the new catalog. We get the following error message :

Reviewed documentation on this error and completed the following trouble shooting steps:

1. Temporarily lowered the UAC settings to none (it was previously as high as it can go) for the deployment and then restarted SQL Server Integration Services 15.0
2. SQL Server Configuration Manager > SQL Server Services > SQL Server Integration Services 15.0 > right clicked & hit properties to inspect the Log On As user. Then navigated to Local Security Policy > Local Policies > User Rights Assignment > and verified that this user is showing in "Log on as a service"

Answer 1

Hi @Hannah Milam,

If you change the SSIS service account from the default, you may have to give additional permissions to the non-default service account before you can deploy packages successfully. If the non-default service account doesn't have the required permissions, you may see the following error message.

A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": System.ComponentModel.Win32Exception: A required privilege is not held by the client.

This error is typically the result of missing DCOM permissions. To fix the error, do the following:

1. Open the Component Services console (or run Dcomcnfg.exe).
2. In the Component Services console, expand Component Services > Computers > My Computer > DCOM Config.
3. In the list, locate Microsoft SQL Server Integration Services xx.0 for the version of SQL Server that you're using. For example, SQL Server 2016 is version 13.
4. Right-click and select Properties.
5. In the Microsoft SQL Server Integration Services 13.0 Properties dialog box, select the Security tab.
6. For each of the three sets of permissions - Launch and Activation, Access, and Configuration - select Customize, then select Edit to open the Permission dialog box.
7. In the Permission dialog box, add the non-default service account and grant Allow permissions as required. Typically, an account has Local Launch and Local Activation permissions.
8. Click OK twice, then close the Component Services console.

For more info about the error described in this section and about the permissions required by the SSIS service account, see the following blog post:

• System.ComponentModel.Win32Exception: A required privilege is not held by the client while Deploying SSIS Project

If this does not work, please run the SQL Repair Installation Option for a try.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.