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

    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
    Location
    Nottinghamshire, UK
    Posts
    364
    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 ?

    GW
    "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
    Location
    San Antonio, TX
    Posts
    565
    check your windows event logs and check your SQL Server Error Logs.

    sp_readerrorlogs

    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
    Location
    Montreal, Canada
    Posts
    117
    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)
    Steve

Posting Permissions

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