SQL 代理未启动 SSIS 包
我有一台具有 SQL 代理作业设置的服务器，用于运行两部分数据仓库构建和 Analysis Services 多维数据集构建。该作业一直成功运行，直到 Management Studio 出现问题并重新安装 .NET Framework 2.0 SP1。 SQL代理作业的第一步是无法启动SSIS包。如果代理作业在步骤 2 中启动，它将运行。
SQL 代理服务已设置为使用管理员帐户，该帐户是 SQL Server 安全中的域管理员帐户和系统管理员。下面的链接遵循对 SSIS 包执行进行故障排除的步骤。
http://msdn.microsoft.com/en-us/library/dd440760。 aspx
保护级别已设置为 DontSaveSensitive。 SQL 代理帐户有权运行 dtexec.exe，并且设置代理帐户也无法解决问题。 Z如果从 Management studio 手动启动，SSIS 包将运行。
重新部署该包并再次设置代理作业并不能解决该问题，并且如果从文件系统而不是 msdb 位置运行该包也会引发相同的错误。
SQL 代理抛出的错误是用户域名\sqlagentaccount 拒绝访问。
对此问题的任何进一步帮助将不胜感激。
I have a server that has a SQL Agent job setup to run a two part datawarehouse build and Analysis Services cube build. The job ran successfully until there was a problem with Management Studio and .NET framework 2.0 SP1 was re-installed. The first step in the SQL Agent job is unable to kick off the SSIS package. If the Agent job is started at step 2 it will run.
SQL agent service has been setup to use the Administrator account which is a domainh admin account and a sysadmin in the SQL Server security. The steps to troubleshoot SSIS package execution were followed from the link below.
http://msdn.microsoft.com/en-us/library/dd440760.aspx
The protection level has been set to DontSaveSensitive. The SQL Agent account has rights to run dtexec.exe and also setting up a proxy account did not resolve the issue. ZThe SSIS package will run if started manually from Management studio.
Redeploying the package and setting up the Agent job again does not resolve the issue and the package also throws the same error if run from the file system as opposed to the msdb location.
The error that the SQL Agent is throwing up is access denied by user domainname\sqlagentaccount.
Any further assistance on this issue would be greatfully appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
听起来你需要在 dcomcnfg 中浏览一下。
我忘记了确切的细节，但您需要设置/修复一些权限。
MS KB 2000474 使用常规搜索
Sounds like you need to poke around in dcomcnfg.
I forget the exact details but you need to set/fix some rights.
MS KB 2000474 found using a general search
我猜您用于代理的帐户对文件系统没有足够的权限。检查因重新安装.Net Framework而修改的文件夹。如果我没记错的话，该帐户应该有权访问 .net Framework 文件夹。
I guess the account you use for Agent does not have enough permissions on the file system. Check the folders that were modified by the re-installation of .Net framework. If I remember correct the account should have access to the .net framework folders.