SQL server 2008 agent无法正常启动

Question

SQL SERVER 错误：805，SSL提供程序：证书链是由不受信任的颁发机构颁发。

Answer 1

What's sql agent service account?

Answer 2

Hi sjnewcity,

 

从sql server configuration manager 中查看sql server agent的启动账户：

 

 

Sql server 2008 已经不受微软支持，请使用新版本的sql server。

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 3

Actually, i combinded sql account with the server login account, so the sql server account is the windows server account. For the sql agent service account, i tried serveral accounts like local service account, network service account and windows server login accouts. They all do not work.



Answer 4



Answer 5

Hi sjnewcity,

 

从sql server configuration manager 中查看sql server agent的启动账户：

 

 

Sql server 2008 已经不受微软支持，请使用新版本的sql server。

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

那么请你尝试使用上面个本地系统账户

---

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 7

经排查和账户没有关系

以下链接可以解决这个问题

https://www.sqlservercentral.com/forums/topic/sqlserver-error-805-ssl-provider-the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-sqlstate-08001