cannot write to log files

• Hollyz

  SSCommitted

  Points: 1763

  More actions

  June 14, 2012 at 8:38 am

  #392522

  Writing to log files is only allowed to jobs that are owned by sysadmin. Please consider writing log to table.

  i have sql 2005 and job is owned by non-sa sql account called dev1.

  i created a proxy account -- workgroup1\proxy and also add this to sql windows login with SA privilege. This account also has Administrative rights to that computer.

  Now this computer is not in a domain, it is in a workgroup.

  I then created the necessary credentails associated with ##xp_cmdshell_proxy_account## using that proxy windows account.

  I then create a sql proxy called: ProxySQL and granted operating systems command, active x and ssis packages. The princpals i added are: workgroup1\proxy and the non-sa owner which is dev1 sql account. The job step that execute this is is using SQLcmd has RUN as ProxySQL.

  When the dev1 sql account calls the job, the job gets that error message above. It is trying to write to an output file.

  The sql service and sql agent are both running under local system accounts.

  I then changed the sql agent account to run as workgroup1\proxy since it has administrative rights. When the dev1 sql account tries to call that job, again it has that same error.

  Anyone have encountered this type of error on a workgroup sql server?