Sample Header Ad - 728x90

What context does the agent service account use (logon account or the NT SERVICE\SQLSERVERAGENT)?

-1 votes
1 answer
199 views
My SQL server agent service account is running under the following domain user account: mydomain\svc_svr1_sql_agent I have a ssis package that must be able to read/write files in a folder. The ssis package is invoked by a SQL agent job. The execution context (the execute as drop-down) is the SQL server agent service account (I am not using the proxy/credentials approach). Should I configure the folder permissions for agent service account mydomain\svc_svr1_sql_agent or the agent virtual account NT SERVICE\SQLSERVERAGENT or both? The reason for asking this question is that, based on https://dba.stackexchange.com/questions/331488/what-are-the-post-steps-after-changing-sql-engine-and-agent-accounts/335928#335928 , the SQL server engine account accesses the SQL data and SQL log files, etc using the NT SERVICE\MSSQLSERVER account irrespective of the SQL server engine service account configuration. So I would like to know how if this concept also applies to the SQL agent.
Asked by variable (3590 rep)
Feb 16, 2024, 02:04 PM
Last activity: Feb 23, 2024, 09:46 PM