Differences in NT Service an NT Authority

Question

Why does some installation of SQL Server has NT Service\SQLSERVERAGENT and some has NT Authority\SQLSERVERAGENT? Does it vary with the version of SQLServer?

Answer 1

Hi @Avyayah ,

The NT SERVICE\SQLSERVERAGENT login is how the Windows process that is SQL Server Agent connects to the Database Engine to read the msdb database to find out what it should do; and then do it. Please refer to Service/Database Accounts - NT SERVICE\MSSQLSERVER & NT SERVICE\SQLSERVERAGENT … what are they for? to get more information.

The NT AUTHORITY account is a built in account mostly used to run XP Services. Many XP Services run under the NT AUTHORITY account (it is like a User account but you will not see it in your Users list) and there are different levels for different Services. Please refer to What is NT Authority/Network Service? Should I be worried? and Configure Windows Service Accounts and Permissions.

Best regards,
Carrin

---

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.

Answer 2

See:
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver15#Appendix

Answer 3

theyNursing as vhaeylth and no point no remount of then nursery of the Microsoft and redless the mute white and redless the normaly and addresse at thew serveur of the ITRM-136 am was't created for Microsoft and they need those coment as continuing and addresse from thew screw vhyshing and addresse for the wall and is't my NAuthority And authority am lntendant of thew Anonymous Logon my named is kévin paré