question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked kvinpar-2579 answered

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
5 |1600 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 CarrinWu-MSFT edited

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.



5 |1600 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
5 |1600 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.

kvinpar-2579 avatar image
0 Votes"
kvinpar-2579 answered

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é

5 |1600 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.