SSIS Package Deployment Error on SQL Server 2019 Enterprise – error occurred during execution of user-defined … aggregate "deploy_project_internal"

huangapple go评论64阅读模式
英文:

SSIS Package Deployment Error on SQL Server 2019 Enterprise - error occurred during execution of user-defined ... aggregate "deploy_project_internal"

问题

I have the following error while deploying SSIS package:

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 System.ComponentModel.Win32Exception: at Microsoft.SqlServer.IntegrationServices.Server.ISServerProcess.StartProcess(Boolean bSuspendThread) at Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName) . (Microsoft SQL Server, Error: 6522)

I use: SSIS version 4.3 deploy it on SQL Server 2019 with SQL Server Management Studio 18.11.1

Everything works fine on the test environment with the same software stack as on production (where the described problem exists). I suppose, that because of the fact that on the problematic production environment there are more restrictive domain settings, so something is blocking the deployment.

I found similar posts:

Following the advises from the above post I repaired the SQL server installation, but they haven’t helped.

英文:

I have the following error while deploying SSIS package:

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 
System.ComponentModel.Win32Exception: at 
Microsoft.SqlServer.IntegrationServices.Server.ISServerProcess
.StartProcess(Boolean bSuspendThread) 
at Microsoft.SqlServer.IntegrationServices.Server.ServerApi.
DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, 
SqlString projectName) . (Microsoft SQL Server, Error: 6522)

picture from SQL Server Management Studio

SSIS Package Deployment Error on SQL Server 2019 Enterprise – error occurred during execution of user-defined … aggregate "deploy_project_internal"

I use: SSIS version 4.3 deploy it on SQL Server 2019 with SQL Server Management Studio 18.11.1

Everything works fine on the test environment with the same software stack as on production (where the described problem exists). I suppose, that because of the fact that on the problematic production environment there are more restrictive domain settings, so something is blocking the deployment.

I found similar posts:

Following the advises from the above post I repaired the SQL server installation, but they haven’t helped.

答案1

得分: 2

如果您遇到错误

> 在执行用户定义的例程或聚合“deploy_project_internal”期间发生了.NET Framework错误:System.ComponentModel.Win32Exception:客户端没有所需的特权

然后请确保将SQL Server服务帐户添加到“User Rights Assignments”中的“Replace a process level token”本地安全策略中,在secpol.msc控制台中。更改权限需要重新启动SQL Server服务。

英文:

If you encounter an error

> 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

then make sure that the SQL Server service account is added to the Local security policy “Replace a process level token” in ‘User Rights Assignments‘ in the secpol.msc console. A restart of the SQL Server service is required to change the permissions.

答案2

得分: 0

遇到了一个问题,本地安全策略中的“替代进程级令牌”没有NT SERVICE\MSSQLSERVER权限。这是因为公司的网络安全策略出于某种原因不允许这样做。为了进行必要的更改,而不改变从域继承的总体安全策略,我不得不通过在NETWORK SERVICE上运行SQL Server来修改虚拟机(NETWORK SERVICE位于“替代进程级令牌”中)。

英文:

I encountered a problem where the Local Security Policy “Replace a process level token” did not have the NT SERVICE\MSSQLSERVER rights. This was due to the fact that the company's network security policies did not allow it for some reason. To make the necessary change without altering the overall security policies inherited from the domain, I had to modify the virtual machine by running SQL Server on the NETWORK SERVICE (NETWORK SERVICE was in the “Replace a process level token”).

huangapple
  • 本文由 发表于 2023年4月13日 18:53:39
  • 转载请务必保留本文链接:https://go.coder-hub.com/76004572.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定