question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked ·

Differences in NT Service an NT Authority

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?

sql-server-general
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered ·

Hi @SahaSaha-5270,

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.



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered ·
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.