December 14, 2022 at 9:16 am
Hi Experts,
How can I rectify the below error in SQL Agent log.
[298] SQLServer Error: 805, SSL Provider: The certificate chain was issued by an authority that is not trusted. [SQLSTATE 08001]
[298] SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001]
How can we identify when client is trying to connect. This error is there always after server restart.
egards
December 14, 2022 at 1:43 pm
Sounds like you have encrypted connections enabled, but haven't set up certificates for those connections. How do you resolve it after the reboot currently?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 16, 2022 at 9:06 am
Thanks Grant for the reply,
how can we identify which connection it is? it is not resolved yet .
December 16, 2022 at 12:47 pm
Your best bet to see missed connections is setting up an Extended Event session and capturing the even connectivity_ring_buffer_recorded. That's the one mechanism I know that captures stuff like timeouts. Otherwise, SQL Server doesn't show you the connections that didn't make it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply