'Execute SSIS package with Proxy - Could not get proxy data for Proxy_id

I am trying to execute an SSIS package using a Credential and Proxy - it works fine with a user with a SysAdmin role and we want to avoid using SysAdmin.

I have followed all the steps to create a Credential and Proxy and set up the permissions for the user in msdb and SSISDb tables and in the Security -> logins

I have followed the steps in the below links as a guide:-

Proxy -> properties -> Principals

enter image description here

When I run the job I get the below error - looks like a permission issue

Unable to start execution of step 1 (Reason: Could not get proxy data for proxy_id = 198_. The step failed.

enter image description here

What am I missing?

sql-serverssisproxyssmssql-server-agent


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions