英文:
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
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”).
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论