Hi everybody,
I've had this error message with SQLServer Agent service.
I use a domain account to start this service. This account is not a Local Administrator.
I've added this account on the specific SQL Agent Group:
Default instance: SQLServerSQLAgentUser$ComputerName$MSSQLSERVER
or
Named instance: SQLServerSQLAgentUser$ComputerName$InstanceName
The error message i've get was:
----------------------------------------------------------------------------
Services
The SQLSERVERAGENT service on Local Computer started and then stopped.
services stop automatically if they have no work to do, for example, the Performance Logs and Alerts Services
---------------------------------------------------------------------------------------
To solve this, i've checked Access control lists for the SQL Agent group.
To do this, please read the following article:
http://msdn.microsoft.com/en-us/library/ms143504.aspx
Now, all is alright 😀
Good luck !!
Bye
Gurvann