We used to have cases where our customer faced the following error messages like following:
- ERROR [08S01] [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host.
- ERROR [08S01] [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure
In this video below we going to provide us some insights about it.
Why this issue happens?
- Application or network issue at client level that closed unexpectedly the connection to the database
How to find the issue?
- Application Error messages: mainly followed by client driver names or protocols (ODBC/ TCP)
How to Fix the issue?
- Look for network issues.
- Check performance on target/application server
- Implement the retry-logic at connection and command execution.
In this video we will cover scenarios causing error - Communication link failure
Enjoy!
