I have a SSIS package which was failing to execute from a SQL Server Agent job with the following error:
Unable to start execution of step 1 (reason: JobOwner EUR\s2sqlhotelldb01 doesn’t have permissions to use proxy 8 for subsystem SSIS). The step failed.
I solved the problem by changing the owner of the job to the account which is used for the proxy and then I granted the account the rights to use the proxy. Funny, but it works.
Here is the script:
dbo.sp_grant_login_to_proxy @login_name = N‘xxx\xxxxx’, @proxy_name = N‘ProxyName’;