Windows Permissions to run Backup SSIS in 2005 -
02-23-2006
, 10:10 AM
Hi,
I am trying to schedule a backup job that uses a proxy account. Looking in
BOL (Dec 2005) It mentions that the account be a member of sysadmin in
SQL2005 and have 6 Windows permissions. I have defined the Windows account
to SQL2005, as a login and made it a member of sysadmin server role, that is
setup as the proxy. I made it e member of the SQLAgentOperatorRole in msdb.
I have also made it have
Adjust memory quotas
Act as part of the os
Bypass traverse checking
Log on as a batch job
Log on as a service
Replace a process level token
just as BOL outlines yet I still get The process could not be created for
step 1 of job 0xFB793AAFF63E684D85344786C3E856D1 (reason: A required
privilege is not held by the client). The step failed.
Chris Wood |