Post reply

User for SQL Server Job

  • 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?

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply