由于客户未持有所需的Prvilage,因此无法部署SSIS包 [英] Unable to deploy SSIS package due to A required Prvilage not held by the client
问题描述
我有一个SQL Server 2016的实例,我正在使用SSDT VS 2017.我创建了一个简单的包,它从平面文件源加载数据并将其加载到数据库。我拥有该机器和SQL Server的完全管理权限,并且该包在设计器中运行良好
。我已经创建了一个目录,但是当我部署该软件包时,我收到以下错误:
标题:SQL Server Integration Services
------------------------------
在执行用户定义的例程或聚合"deploy_project_internal"期间发生.NET Framework错误:
$
System.ComponentModel.Win32Exception:客户端未保留所需的权限
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,错误:6522)
如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft%20SQL%20Server& ProdVer = 13.00.5081& EvtSrc = MSSQLServer& EvtID = 6522& LinkId = 20476
----------------- -------------
按钮:
OK
- ----------------------------
我甚至试图导出包并创建一个代理作业以便以这种方式运行它但也出错了,虽然我找不到原因而且这不是我熟悉的东西。我已经远程搜索了互联网,但无论我尝试什么,我都无法获得任何SSIS工作。任何想法从哪里开始?
提前感谢
你好SQL_Chris _,
" ... 但是当我来部署软件包时,我收到以下错误:..."
首先,我希望您在"项目部署"模式下将整个SSIS项目而不是单个SSIS包部署到SSISDB目录。你在那里手动创建了一个文件夹。
请分享你的部署方式:
- 直接在VS2017中。
- 在带有* .ispac文件的SSMS中。
I have an instance of SQL Server 2016 and I'm using SSDT VS 2017. I've created a simple package that loads data from a flat file source and loads it to a database. I have full administrative rights to the machine and SQL Server and the package runs fine in the designer. I have already created a catalogue however when I come to deploy the package i get the following 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=13.00.5081&EvtSrc=MSSQLServer&EvtID=6522&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I even tried to export the package and create an agent job to run it that way but that errors out too, although I can't find the reason why and it's not something I am familiar with. I've searched the internet far and wide but no matter what I try I cannot seem to get any SSIS job working. Any ideas where to begin?
thanks in advance
Hi SQL_Chris_,
"...however when I come to deploy the package i get the following error:..."
First of all, I hope you are deploying the entire SSIS project, not a single SSIS package, in a 'Project Deployment' mode to the SSISDB catalog. And you manually created a Folder there.
Please share how you are deploying:
- Directly in VS2017.
- In SSMS with *.ispac file.
这篇关于由于客户未持有所需的Prvilage,因此无法部署SSIS包的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!