SSIS job fails when run as a scheduled job - access denied

Question

SSIS job fails when run as a scheduled job - access denied

Michael Harris 20

I created a job to export 4 SQL 2019 tables to an Excel workbook using the Export Data task to create the SSIS package in SSMS. The process works fine in SSMS but when I run the created SSIS package in SQL Agent, it fails due to access denied. It seems like it happens in the Excel portion of the job. I've tried running as a command line using DTEXEC with the same result. I tried creating a proxy account but I'm not sure it is setup correctly. How can I get past the error?

Michael Harris 20 Reputation points

2025-05-09T17:21:52.8966667+00:00

Unfortunately, this did not work. It fails with the error: A required privilege is not held by the client. I'm not sure the proxy/credentials are set up correctly. I created the proxy and set it to work with an administrator's account on the server. It doesn't seem to be working
Michael Harris 20 Reputation points

2025-05-09T17:24:54.9966667+00:00

It gave me an error that said, A required privilege is not held by the client. I'm not sure the proxy/credential was setup up properly. I tried to point it to an account that has administrator privilege but it doesn't seem to be using that

Accepted answer

0 additional answers

Your answer

Michael Harris 20 Reputation points

2025-05-09T17:21:52.8966667+00:00

Unfortunately, this did not work. It fails with the error: A required privilege is not held by the client. I'm not sure the proxy/credentials are set up correctly. I created the proxy and set it to work with an administrator's account on the server. It doesn't seem to be working
Michael Harris 20 Reputation points

2025-05-09T17:24:54.9966667+00:00

It gave me an error that said, A required privilege is not held by the client. I'm not sure the proxy/credential was setup up properly. I tried to point it to an account that has administrator privilege but it doesn't seem to be using that

Answer 1

Olaf Helper 46,791

it fails due to access denied.

By default a SQL Agent Job SSIS step runs under the Agent service account and by the error message this account don't have the permissions to access the Excel file.

Grant permissions for that account or better use an Agent proxy account with e.g, your credentials, see

Create a SQL Server Agent proxy

Share via

SSIS job fails when run as a scheduled job - access denied

0 additional answers

Your answer