We used to have cases where our customer faced the following error message: "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)" in this video below we are going to give some insights about it.
Why this issue happens?
Connection dropped from SQL Server or network issue during execution of a query.
How to fix the issue?
Reopen the connection and Retry the TSQL operation.