SQL Agent Service Account

• bbk0919

  Old Hand

  Points: 387

  More actions

  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.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  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