Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2005
    Greenwood, MS

    Unanswered: SQLSERVERAGENT service will not start

    I restarted the MSSQLSERVER service and SQLSERVERAGENT will not restart.
    I get the following error.

    Could not start the SQLSERVERAGENT service on Local Computer.
    The service did not return an error. This could be an internal Windows erroror an internal service error.
    If the problem persists, contact you system administrator.

    Well the system administrator has no idea.

    I am new at this.
    please give me a hand.

  2. #2
    Join Date
    Jan 2003
    Nottinghamshire, UK
    Try looking at the Logon account of the SQLSvrAgent in Control Panel/Services

    Has it changed and been activated with the reboot ?

    try running it as local account - try to start it with different accounts.

    Have you checked the Event Log for startup service failures ?

    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  3. #3
    Join Date
    Feb 2004
    San Antonio, TX
    check your windows event logs and check your SQL Server Error Logs.


    if the service was running and now it is not, check the service account that it runs under. if a service account is used, check that the password has not been recently changed or that the account has had its group memberships changed. in addition (assuming you are a member of a domain), make sure that the computer is a domain member and that someone hasnt modified its computer account. this is unlikely but check anyway.

    also make sure the mssqlserver service is running as you cannot start the agent without the server.

  4. #4
    Join Date
    Feb 2003
    Montreal, Canada
    If agent runs under LOCALSYSTEM account, check if you didn't drop by mistake your BUILTIN\Administrator account.(EM->Security) (SQLServer Agent uses this account in this case)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts