sql server Agent proxy account to execute jobs

• L_avital

  Ten Centuries

  Points: 1379

  More actions

  February 18, 2009 at 11:57 am

  #155290

  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?

  LL

• john j serna

  SSChasing Mays

  Points: 630

  More actions

  March 26, 2010 at 10:58 am

  #1140563

  Hi, yo must set your SQL Server service account as a local adminsitrator of Windows