June 1, 2011 at 2:17 pm
Hi All,
I have SQL 2005 Standard Edition SP2. When I check SQL Server Agent Log on type, it is set to Local System Account. I would like to change it to Domain Account. Can I simply change that from Configuration Manager/Services.msc ? Do I need to take any other steps?
Also, there are many jobs scheduled on this server. Will there be any issue on these jobs if I make this change?
Thanks in advance...
June 1, 2011 at 2:30 pm
do it through configuration manager and ONLY configuration manager. all required permissions will be taken care of that way.
Before the agent was running with local admin rights so would have had access to any directory on the server. Under a domain account this would not necessarily have local admin so you could get access permission problems if you have sqlagent jobs that break out of SQL, e.g. running a bcp out. In that case you would need to create shares and grant access to the SQL service account.
---------------------------------------------------------------------
June 1, 2011 at 2:35 pm
Thanks for the quick reply George. One more question,
If SQL Server Service still runs under Local System Account and SQL Agent is Changed to run under Domain Account, that doesn't matter right?
June 1, 2011 at 3:12 pm
It will work.
Personally I run them under the same account.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply