SSIS – “Could not load package because of error 0xC00160AE ” – “Access is Denied”

Error

Error Message

Could not load package “\MSDB\ImportData” because of error 0xC00160AE.
Description: Connecting to the Integration Services service on the computer “LAB-DB” failed with the following error: “Access is denied.”

Error Image

 

Remediation

Component Services

Global

Objective

Add SQL Server Agent Proxy Account to the local “Distributed COM Users” group.

This allows the proxy account to launch and activate all COM Objects on the local machine.

Image

Specific Objects

Steps

  1. Launch “Component Services” and navigate to each “Microsoft SQL Server Integration Services” component.
  2. Right click on each such component and grant permission to each Integration Service Component.
    • Access the Services Tab
      • Group box :- “Launch and Activation” permissions
        • Access the “Launch and Activation” permissions group box
        • Ensure the “Customize” option is chosen
        • Click the “Edit” button
        • Grant your proxy account “Local Launch” and “Local Activation” access
      • Group box :- Access permissions
        • Access the “Access” permissions group box
        • Ensure the “Customize” option is chosen
        • Click the “Edit” button
        • Grant your proxy account “Local Access
    • Restart relevant Sql Server Integration Services

Images

Microsoft SQL Server Integration Services
Security
Security – Launch and Activation Permission

 

Security – Access Permission

 

Services Applet

SQL Server

msdb

Objective

Please make sure that proxy account has access to the msdb database and that it has been granted membership in the db_ssisoperation role.

Syntax


USE [msdb]
GO
if user_id('account') is null
begin

    CREATE USER [proxyAccount] FOR LOGIN [proxyAccount]

end

ALTER ROLE [db_ssisoperator] 
   ADD MEMBER [proxyAccount]
GO

References

  1. Microsoft
    • Docs
      • Docs / SQL / SQL Server / Integration Services / Service
        • Integration Services Service (SSIS Service)
          Link
    • Technet
      • Integration Services > Integration Services Features and Tasks > Security
        • Integration Services Roles (SSIS Service)
          Link
  2. StackExchange
    • How do I grant the privilege of connecting to SSIS?
      Link

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s