Share via

NTSERVICE\SQLSERVERAGENT - unable to locate this account for applying permissions

Mudit Dhebar 101 Reputation points
2021-08-31T03:16:14.397+00:00

Hi Team,

I am trying to run a package via SQL agent.
The job gets failed due to error message "Access is denied". I understand that the user NTSERVICE\SQLSERVERAGENT needs to have the permission to execute the package file as well as dump it to the destination folder.

I have tried by checking security tab where we select the computer to get all the service account list , however I could not find this account.

Where do I find this account in context to giving it a permission of read/write for a specific folder?

Thanks in Advance.

Kind Regards,
Mudit

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
0 comments
Accepted answer
  1. Mudit Dhebar 101 Reputation points
    2021-09-07T21:42:43.887+00:00

    @ZoeHui-MSFT - thanks for your help. It's fixed now. apologies i wasn't well.

    What I discovered that if you type nt service and search for the account it does not show up, howerver it you type nt service\sqlserveragent and search , it replaces with SQLSERVERAGENT. This means we can't find the account manually, good to know anyway.

    Kind Regards,
    Mudit

    1 person found this answer helpful.

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,496 Reputation points
    2021-08-31T05:27:44.417+00:00

    Hi @Mudit Dhebar ,

    Just right-click the <MSSQLPATH>\MSSQL\Binn\ folder where sqlagent.exe resides, then choose > Properties > Security, then check to make sure that 'NT Service\SQLSERVERAGENT' account has execute permission within the folder.

    127801-screenshot-2021-08-31-132712.jpg

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    1 person found this answer helpful.
    0 comments
  2. Olaf Helper 47,516 Reputation points
    2021-08-31T06:54:32.267+00:00

    The better option is to use a SQL Server-Agent proxy account with the required permissions: Create a SQL Server Agent Proxy

    0 comments
  3. Mudit Dhebar 101 Reputation points
    2021-09-01T06:26:19.297+00:00

    Thanks , Zoe.

    I can't find the account itself when i search it using the current computer location.

    Kind Regards,
    Mudit

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.