Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My instance of SQL Server 2008 SP1 crashed, which is a separate issue, and I see the following set of messages in the SQL Server Agent log:

[139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #1)...
[368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)

Is there an authoritative place that describes what permissions should be assigned to a domain account that the SQL Server Agent runs as?

Thank you!

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

http://support.microsoft.com/kb/283811

If the account that the MSSQLServer service is going to start with is one of the following two accounts, you must add the startup account for the MSSQLServer and the SQLServerAgent services, or both, to the SQL Server sysadmin)role, and grant the [Domain\NTaccount] user a logon to SQL Server.

share|improve this answer
    
Thank you, exactly what I was looking for! –  Michael Teper Dec 8 '09 at 20:29
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.