Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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