SSDT 2012 - ssis 部署错误 [英] SSDT 2012 - ssis deployment error

问题描述

我正在尝试使用部署选项部署 SSDT 2012 SSIS 项目.但我收到以下错误:

<块引用>

标题:SQL Server 集成服务

在执行用户定义的例程或聚合deploy_project_internal"期间发生 .NET Framework 错误:System.ComponentModel.Win32Exception:客户端未持有所需的权限System.ComponentModel.Win32Exception:在 Microsoft.SqlServer.IntegrationServices.Server.ISServerProcess.StartProcess(Boolean bSuspendThread)在 Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName).(Microsoft SQL Server，错误:6522)

如需帮助，请单击:

I am trying to deploy a SSDT 2012 SSIS project using Deploy option. But I am getting below error:

TITLE: SQL Server Integration Services

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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.5058&EvtSrc=MSSQLServer&EvtID=6522&LinkId=20476

Any idea why this error? below is the screen shot of the error.

解决方案

That error often means the SQL Server Agent account is missing a permission somewhere. The "A required privilege is not held by the client" in this case means the SQL Agent account is called to do something but isn't permitted to.

One thing to try is to use the SQL Server Configuration Manager, as administrator, to reset the account for SQL Server Agent (and possibly SQL Server itself). This will reinstate the required permissions if you have sufficient rights.

I have seen cases where Group Policy prohibited the assignment of the service account to needed permissions at the OS level, which really creates a problem.

Example: http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/08/20/error-while-deploying-ssis-2012-project-from-ssdt-to-ssis-catalog-system-componentmodel-win32exception-a-required-privilege-is-not-held-by-the-client.aspx

这篇关于SSDT 2012 - ssis 部署错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！