Getting below errors from the client side while coonecting to SQL On prem Server

Question

OLE DB provider "SQLNCLI11" for linked server "SQLAPP1" returned message "Communication link failure".
OLE DB provider "MSOLEDBSQL" for linked server "SQLAPP1" returned message "Protocol error in TDS stream".
TCP Provider: An existing connection was forcibly closed by the remote host.
(provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Answer 1

Hi @Jeremy Edmond ,

Protocol error in TDS stream

When you encounter this error, it most likely means that corrupted driver installations or server physical network error
You may consider reinstalling the driver and check your network hardware

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Please run the PowerShell script contained on this article. It has saved me of those Error 0 SSL connectivity errors a few times already.