Hello, I am created a proxy account for SQL Server Agent (sql server 2000, sp4)as described by microsoft. IT created a domain user with needed permissions. I added this proxy executing xp_sqlagent_proxy_account 'SET', 'DomainName', 'AccountName', 'AccountPassWord'
Then ran msdb..sp_set_sqlagent_properties @sysadmin_only = 0
Then executed xp_sqlagent_proxy_account 'GET' to make sure it is there.
Then gave this loggin access to master db and execute permissions on xp_cmdshell (maybe not necessary).
Granted userdb access to testuser, sql loggin that will be the job owner.
also granted this testuser exec on xp_cmdshell.
The job is to execute a simple select of one field and put in a txt file on D:/admin on the server.
When executed got this error:
xp_cmdshell failed to execute because CreateProcessAsUserW returns error 1314. please make sure the service account SQL Server running under has appropriate privilege.
I checked the privileges of proxy on the server and it had all but Increase Quotas . Can this be a reason for the failure? Also if it is what quotas are these in case I need to add it?