• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

'NT AUTHORITY\SYSTEM' get converted to 'NT AUTHORITY\NETWORK SERVICE'

even if the job is at System, it gets converted to NS; why is this? what setting causes this?

thanks
0
anushahanna
Asked:
anushahanna
  • 3
  • 3
1 Solution
 
dodge20Commented:
I'm not quite sure what you are asking, but what account is your agent started as?
0
 
anushahannaAuthor Commented:
the job owner is NT AUTHORITY\SYSTEM; the service account is NETWORK SERVICE.

in the audit info of who created the data record through the job, it shows NETWORK SERVICE and not SYSTEM.
0
 
dodge20Commented:
SQL Jobs run under whichever account the Agent runs. This is why you see Network Service. Is the job not working correctly? You may need to choose an account with the appropriate permissions to run the sql agent.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
anushahannaAuthor Commented:
dodge20, the job is working fine, but the question is regarding the ownership of the job. if it is going to override the owner with the service account, why does it even give us the option to change owners?
thanks
0
 
dodge20Commented:
If the job owner is an account that is in the sysadmin fixed server role, then your step will be executed under the account used by the Sql Server Agent service.
Otherwise will be executed by the account set as the job owner, no matter who is starting the job.

You can read more about that here.
http://weblogs.sqlteam.com/dmauri/articles/6914.aspx
0
 
anushahannaAuthor Commented:
>>Otherwise will be executed by the account set as the job owner, no matter who is starting the job.

is it possible to force it to run under the one who is 'starting' the job instead of the job owner?

thanks

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now