Home / server / Questions / 85934
Accepted
Michael Teper
Asked: 2009-11-19 07:56:54 +0800 CST

AutoRestart error in SQL Server logs (reason: Access is denied)

  • 772

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!

sql-server

1 Answers

  1. Best Answer

    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.

    • 0