A SSIS package can be executed using SQL Server agent.
To execute the package a Proxy Account and a credential must be configured in SQL Server.
Problems:
1) Executed as user: DOMAIN\user. The process could not be created for step 1 of job 0xB013D0354C8CBD46B79E948740EF5441 (reason: 1314). The step failed.
The error 1314 is "A required privilege is not held by the client".
This message indicates that the SQL Server Service account doesn't have the required rights to switch the security context to the proxy account.
To fix it verify:
1) The proxy account have the "Act as part of the operating system" privilege.
2) The SQL Server Account is in the group
SQLServer2005MSSQLUser$<server>$<instance>
3) The Proxy account is in the group
SQLServer2005DTSLUser$<server>$<instance>
5 comments:
a little correction:
2) The SQL Server AGENT Account is in the group...
Maciej
It is the SQL Server Account and not the the SQL Server AGENT Account that must be in that group.
At least on my environment...
One more requirement (at least in MS SQL 2008):
SQL Server Agent Account must have 'Adjust memory quotas for a process' (or 'Increase quotas' in pre-Windows 2003) privilege on SQL Server
Learn more about programming SSIS packages in C# .net and VB .net from the below link:
http://www.sqllion.com/2009/05/ssis-programming-basic/
Thanks,
In my case, I had to change SQL Server Agent Log As account to local and switch it back using SSCM to fix the problem. Please refer to http://vijredblog.wordpress.com/2014/06/17/a-required-privilege-is-not-held-by-the-client-the-step-failed-sql-job-fails-with-error-solution/ for more details.
Post a Comment