Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  SSIS proxy "privilege is not held"

Author  Topic  jconway Starting Member 2 Posts Posted - 2010-01-14 : 16:37:14 I am having difficulty running a SSIS job step using a proxy account, but only if the SQL Server and SQL Agent services run under "Network Service". When the services run under "Local System" the job setup works fine. The error message is: Executed as user: DOMAIN\User. The process could not be created for step 2 of job 0x6BCFAD86404958439832D44B757C71D6 (reason: A required privilege is not held by the client). The step failed. The job is owned by SQL User with db_owner for one database but public permissions on the server. The SSIS step runs as a SSIS Package Execution proxy, with the Domain User listed in the error as it's credential, and the SQL User as an authorized Pricipal. The SSIS package is references the local SSIS Package Store, where is was loaded using Rely on Server Storage Roles and Save Sensitive With Password. The Domain User is a memeber of the server's SQLServer2005MSSQLUser user group. Again the error occurs if the SQL Server and SQL Agent services run under Network Service instead of Local System, which completely baffles me. When the services run as a Network Service I am able to sucessfully run the job if I cange the Job owner to a SQL sysadmin and the SSIS execution to SQL Agent, but that's not a desirable solution. Thanks in advance, James