December 20, 2011 at 10:21 am
Hello - I was a developer - new to being a DBA...
I am trying to run a SQL job that imports from the windows operating system directory.
The job history reads
Executed as user: SNJ282\SYSTEM. The package execution failed
The step is a SQL Server Integration Service Package that can only run as SQL Agent Service Account (according to the wizard interface)
Question 1 - Does "SYSTEM" = SQL Agent Service Account?
When I go to
Admin Tools->Services->SQL Server Agent(MSSQLSERVER) logs on as “Local System”
I googled “Local System” and see that I will not be able to launch a SSIS.
Question 2 - Is "Local System" equivalent to any user account at the OS level?
Question 3 - if I have to ask my network admin to create a new account, what permissions should it have?
Question 4 - What is involved (risks, downtime)with switching my SQL Server Agent from local to a user account at the OS level?
Thank you in advance for your help
Dave
December 20, 2011 at 10:51 pm
NJDave (12/20/2011)
Executed as user: SNJ282\SYSTEM.
What kind of privilege this account has ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 10:57 pm
You can find answers for all of your questions here.
Selecting an Account for the SQL Server Agent Service
http://msdn.microsoft.com/en-us/library/ms191543.aspx
Now I have one question to you. Was this user 'SNJ282\SYSTEM' able to run job before? Or you are trying to set it up the job for this user?
December 22, 2011 at 1:24 am
Not sure about your other questions, but "Local System" is a special account which is only used to run services--it effectively has better than Administrator access to the local machine, and presents itself to the network using the computer's computer account. It isn't equivalent to any account you'll find in local users or in Active Directory Users and Computers.
More info:
http://msdn.microsoft.com/en-us/library/windows/desktop/ms684190%28v=vs.85%29.aspx
December 22, 2011 at 1:36 am
paul.knibbs (12/22/2011)
"Local System" is a special account which is only used to run services--it effectively has better than Administrator access to the local machine, and presents itself to the network using the computer's computer account.
i am agree with you but i think this account is not suitable for clustered server.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply