SQL Server Performance Forum – Threads Archive
SQLServerAgent could not be started?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?
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