Post reply

SQL Agent Service Account

  • March 22, 2019 at 12:01 pm

    #371802

    MS SQL 2017. I used SQL Server Configuration Manager to change the service account for the SQL Agent. I restarted the service successfully. I expected to see the new SQL Agent service account (Active Directory domain account) listed as a login, but I do not see it. I created a test job that drops a table and then re-creates a table in one of the databases and the job executes successfully using the new service account. Why do I not see the SQL Agent service account as a login?

    Thanks in advance.

  • March 22, 2019 at 12:40 pm

    #2025263

    bbk0919 - Friday, March 22, 2019 12:01 PM

    MS SQL 2017. I used SQL Server Configuration Manager to change the service account for the SQL Agent. I restarted the service successfully. I expected to see the new SQL Agent service account (Active Directory domain account) listed as a login, but I do not see it. I created a test job that drops a table and then re-creates a table in one of the databases and the job executes successfully using the new service account. Why do I not see the SQL Agent service account as a login?

    Thanks in advance.

    The account is mapped to the service SID which for a default instance would be NT SERVICE\SQLSERVERAGENT
    Configure Windows Service Accounts and Permissions

    Sue

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

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