cancel
Showing results for 
Search instead for 
Did you mean: 

ETL error and what it means

Anon
Community Manager

ETL error and what it means

potential error that can occur when running the ETL via an SQL Agent job looks like this:

Executed as user: XXX\YYY.
The process could not be created for step 1 of job 0x86C30C70952AB04CBEE99DB0D5FDE6AC (reason: A required privilege is not held by the client). The step failed.


The job failed. The Job was invoked by User XXX\YYY. The last step to run was step 1 (PrognosisBDI__Start_ETL_cmd).

This error typically means that the SQL Server Agent has not been configured according to Microsoft recommendations, and the user account used to run the SQL Server Agent is missing some required permissions.

The recommended solution is to consult the Microsoft documentation (https://msdn.microsoft.com/en-us/library/ms191543.aspx) and correct any missing permissions for the SQL Agent Service user.​​
Tags (1)