Permissions to Schedule an SSIS Package from SQL Server Agent and the File System

最新推荐文章于 2020-07-26 16:35:39 发布

Larry-Qian

最新推荐文章于 2020-07-26 16:35:39 发布

阅读量322

点赞数 1

分类专栏： SSIS

SSIS 专栏收录该内容

18 篇文章

订阅专栏

当尝试通过SQL Server Agent运行SQL Server Integration Services (SSIS)包时，可能会遇到“访问被拒绝”的错误。解决此问题需要为执行作业步骤的用户账户提供足够的权限。具体步骤包括：通过Component Services设置DCOM配置、编辑启动和激活权限以及访问权限，并重新启动SQL Server Integration Services服务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Problem

When trying to schedule a SQL Server Integration Services (SSIS) Package to run from SQL Server Agent, you get the following error:

“Connecting to the Integration Services service on the computer “…” failed with the following error: "Access is denied". By default only administrators have access to the Integration Services service. On Windows Vista and later the process must be running with administrative privileges in order to connect to the Integration Services service.”

Connecting to the Integration Services service on the computer failed with the following error: Access is denied.

Solution

As the error message states, the user that is running the job step does not have administration privileges to connect to the Integration Services service even in this case we are using the SQL Server Agent service account.

Follow the next steps to provide the necessary privileges to the account that is running the job step:

Open the Component Services (from the Windows Start menu type “dcomcnfg”)
Drill down to Console Root \ Component Services \ Computers \ My Computer \ DCOM CONFIG as shown in the next figure

Windows Component Services

Locate the entry for the Microsoft SQL Server Integration Services version that you are working with and right-click on it and click on the Properties option. The respective Properties window will pop-up and choose the Security tab

Security tab of Component Services

Edit the Launch and Activation Permissions option and add the user that is running the Job step allowing the Local Launchand Local Activation privileges:

Launch and Activation Permission in Component Services

Edit the Access Permissions option and add the user that is running the Job step allowing the Local Access privilege:

Access Permissions in Component Services

Restart the respective SQL Server Integration Services service

Note For DTSX Packages in the File System

If you are running the dtsx package from the file system and you receive the following error after executing the previous steps, then you will need to give read permissions to the folder for the same user that is running the job step.

Error for DTSX Packages in the File System