SQL Server Agent can not start 代理启动失败

Question

Unable to start service SQLSERVERAGENT on server SERVER1 

Additional information:

                               The SQLSERVERAGENT service on SERVER1 started and then stopped

Answer 1

What's sql agent service account? Does it have proper windows permission?

Answer 2

I get some pics,maybe anything wrong:

Answer 3

Hi EricZom,

 

你给的错误信息太过一般性，能给我们提供一些windows event log 和 sql agent log（默认位置:C:\Program Files\Microsoft SQL Server\MSSQLX.MSSQLSERVER\MSSQL\Log\SQLAGENT.X详细的错误吗？

 

下面这个连接讲述了造成这种错误的一个可能性原因：https://blog.sqlauthority.com/2018/11/03/sql-server-unable-to-start-service-sqlserveragent-on-server-mscorlib/

 

Best regards,

Dedmon Dai

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 4

Thanks a lot , i found the log what you said,check it out:

Answer 5

Hi EricZom,

 

你这个错误信息感觉是你的sql agent无法连接你的sql engine啊，你的sql server service是否启动了？你是否在sql server configuration manger上为sql server启用了named pipe协议？

 

Best regards,

Dedmon Dai

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 6

这几个服务都启用了，看日志说是注册表损坏了，或者注册表信息丢失，不知道用SQLserver的修复功能能不能解决

Answer 7

I get some pics,maybe anything wrong:

You still didn't tell what the sql agent service account is and windows permissions it has, find that in sql server configuration manager. Also check windows application event log for related error details.