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

Question

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

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.

What am I missing?

What is the login type of the proxy account (Windows or SQL Server user)? — Hadi, Feb 20 '22 at 20:57
try using a windows account instead. As I know proxy accounts need to have a windows authentication — Hadi, Feb 21 '22 at 13:56

score 1 · Accepted Answer · answered Feb 21 '22 at 19:37

As you mentioned in the comments, you are using an SQL Server login as a proxy account. While in the Microsoft documentation they mentioned that:

SQL Server Agent proxies use credentials to store information about Windows user accounts. The user-specified in the credential must have "Access this computer from the network" permission (SeNetworkLogonRight) on the computer on which SQL Server is running.

I suggest following one of the following articles to set up an SQL Server agent proxy:

Created a Windows User and it worked fine – Ram Mar 03 '22 at 17:43 — Ram, Mar 03 '22 at 17:43

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

1 Answers1