User for SQL Server Job

• MarkR-251611

  Right there with Babe

  Points: 731

  More actions

  March 16, 2006 at 3:54 pm

  #170935

  I have a SQL Server Job that is trying to delete, rename, etc. files on a network drive. I am getting permission problems when doing this. The job uses the sa user and the step uses (Self). How do I find out the user to give permission to on the file server?

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  March 17, 2006 at 10:41 am

  #627408

  What occurs to me is SA is a SQL Server login and you'd need to have a Windows network login to write to a file server.  Our jobs run as the SQL Server Agent login which is a network account.

  Greg

  Greg