SQL Server Agent won't start | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server Agent won’t start

I cannot start the SQL Server Agent from the SQL Server Service Manager. When I try to start it, it stops immediatly. The event viewer has an entry which states "SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but ‘(Unknown)’ is not a member of the SysAdmin role)." If I try starting SQLSERVERAGENT from Services, I get "Could not start the SQLSERVERAGENT service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error."
All the other SQL services are running. Any advice?
See whether your issue falls under this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;302409 specification. Additionally:
Did any passwords since the last time the agent service was started? You may want to check and see how SQL Server is trying to log in and what permissions it has.
HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Also, right click on SQL Server Agent in EM, go to ‘properties’ and look under the ‘Connection’ tab to see if proper authentication is used.
]]>