Re: Confusion over SQL Server Agent Service Account

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you are using SQL Server 2005 here is the information you are seeking...
http://support.microsoft.com/kb/907557
&
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

"The SQL Server Agent account must have administrator privileges if you
create CmdExec and ActiveScript jobs that belong to someone other than a SQL
Server administrator, or if you use the AutoRestart feature. If the above
features are requirements in your environment, consider using separate
service accounts for the SQL Server and SQL Server Agent services."

Consider using two seperate accounts for SQL Server and Agent since the SQL
Server does not require administrator rights.



thanks,



--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"Marks70" <Marks70@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7DE7F5DC-6542-42BE-838D-A5CB5C5352B2@xxxxxxxxxxxxxxxx
I am going to be creating a Domain User account for both the SQL Server and
SQL Server Agent service accounts to run under. However, I've read in some
Microsoft documentation that the SQL Server Agent needs administrator
privileges if you want to use the auto restart functionality. Is this
correct? So if one of the SQL services terminates, I need to run the SQL
Server Agent service under a local admin. account for it to restart the
services?


.

Relevant Pages