dbTalk Databases Forums  

Windows Permissions to run Backup SSIS in 2005

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Windows Permissions to run Backup SSIS in 2005 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Wood
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.