August 2, 2006 at 2:00 pm
Hi All,
One of my server SQL Agent is failing to start, I could see the below details in the SQL Agent Log. Please let me know if you have any idea about it, that would be highly appreciated.
Agent Error Log
2006-08-02 12:24:21 - ! [298] SQLServer Error: 805, SSL Provider: The certificate chain was issued by an authority that is not trusted. [SQLSTATE 08001]
2006-08-02 12:24:21 - ! [298] SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001]
2006-08-02 12:24:21 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2006-08-02 12:24:21 - ! [298] SQLServer Error: 805, SSL Provider: The certificate chain was issued by an authority that is not trusted. [SQLSTATE 08001]
2006-08-02 12:24:21 - ! [298] SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001]
2006-08-02 12:24:21 - ! [382] Logon to server '(local)' failed (DisableAgentXPs)
2006-08-02 12:24:21 - ? [098] SQLServerAgent terminated (normally)
Warmest
Jayakumar K
Thanks
Jay
http://www.sqldbops.com
August 3, 2006 at 9:26 am
Did you check that the account used to start the SQL Server service is a local admin?
Regards, Melissa
August 4, 2006 at 11:52 am
Thanks for your reply,
I've checked the account, that is in Administrator group only, but still it is failing.
warmest
Jayakumar K.
Thanks
Jay
http://www.sqldbops.com
August 6, 2006 at 8:04 pm
Are you able to connect to SQL Server from Local machine using windows authentication?
Do you have any certificates installed on this machine?
August 29, 2009 at 12:15 am
hi,
Balmukund,
Mirroing has been break due to unexpected restartd the server. NOW WE ARE NOT ABLE TO CONNECT DR SERVER . ERROR IS NOT REACHED TO THE DR OR HOSTNAME IS NOT FOUND.
PLS HELP ME OUT.
Reregards
kumar
September 2, 2009 at 9:09 pm
September 3, 2009 at 2:25 am
If this is not yet fixed, let us know and give us more information so we can help
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
June 10, 2010 at 4:00 pm
I ma getting simialr error as well.
I have tried changing the service account and installing another TEST SQL Server instance. Still getting the simialr error:
SQLServer Error: 805, SSL Provider: The certificate chain was issued by an authority that is not trusted. [SQLSTATE 08001]
SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001]
Unable to connect to server 'SERVER1234\TESTRK'; SQLServerAgent cannot start
SQLServer Error: 805, SSL Provider: The certificate chain was issued by an authority that is not trusted. [SQLSTATE 08001]
SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001]
Logon to server 'SERVER1234\TESTRK' failed (DisableAgentXPs)
SQLServerAgent terminated (normally)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply