Home Forums SQL Server 2005 Administering SQLSERVERAGENT service on Local Computer started and then stopped RE: SQLSERVERAGENT service on Local Computer started and then stopped

  • 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