Post reply

SQL Server Agent 2012 Permissions with domain account

  • December 9, 2015 at 9:52 am

    #306994

    I'm having an issue with permissions. I am running SQL Server Agent under a domain account. The account is a local administrator. When I attempt to run an FTP get session, I cannot write the files to the file system; however, when I run the same batch file for the FTP as a scheduled Task, I have no issues. I somehow cannot figure out how the security context is different.

  • December 10, 2015 at 8:00 am

    #1845225

    does the account have write permission to the file location? Sometimes local admin doesn't always mean account has free reign over everything.

    another option instead of adding permission to the AD account, you can add permission on the file location to "NT Service\SQLSERVERAGENT". This way, if you change the agent service account, permissions will not be lost.

    you can check the user account context by adding "echo %username% > c:\temp\username.txt" to your batch file. this should tell you the context your job is running in.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • December 10, 2015 at 8:03 am

    #1845227

    Make sure no proxy is set and ensure that the job itself has the account correctly chosen. There are various ways to change this, and configure different accounts for a job.

  • December 10, 2015 at 8:29 am

    #1845241

    Thanks for the help. I granted SQLSERVERAGENT rights to the needed directories and it now runs.

Viewing 4 posts - 1 through 3 (of 3 total)

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