SQL Server Performance

SQLServerAgent could not be started?

Discussion in 'General DBA Questions' started by cwhitmore, Dec 5, 2002.

  1. cwhitmore New Member

    I'm getting this error when the agent tries to start. I've rebooted the server, tried using a different login for the service, but it will not allow me to start it. The complete error is below:

    SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

    Any ideas?
    Carlton.
  2. bradmcgehee New Member

    Assuming you have ruled out all security issues, try the following:

    Check the following registry key.

    HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INISQL ServerDriver

    It should be pointing to c:[windows folder]system32SQLSRV32.dll

    When the above registry key does not exist, or if the value is not correct, this error message you provided may be returned. If the registry key is not present, you can try to add it if you want, but I recommend that if it is missing for you to reinstall the MDAC software.

    If the key is correct, consider reinstalling MDAC anyway to solve the problem.
    You can download the latest MDAC fromhttp://www.microsoft.com/data

    Also, consider reading through this article on Microsoft's website for additional assistance on how to best troubleshoot this problem if the above suggestions don't work.

    http://www.microsoft.com/technet/tr...rodtechnol/sql/reskit/sql7res/part7/sqc09.asp



    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page