An existing connection was forcibly closed by the remote host
Posted by Simon Cho on 01/19/2018
A couple of cases for this error message.
- Network device hardware failure.
- Old Driver version
- SQL bug. Please check the latest patch.
- TCP Chimney setting and the SyncAttackProtect setting.
- AG listener or Endpoint port misconfiguration.
- Encryption/Decryption issue during data transit.
- SSL or TLS cipher mismatch
- AG endpoint encryption method discrepancy.
- During AG or Mirroring failover transit.
- Network packet loss due to any reason
- Firewall blocking for certain case.
- Jumbo frame or MTU size misconfiguration.
- Login Authentication issue.
https://sqlperformance.com/2013/11/system-configuration/ag-connectivity
https://blogs.msdn.microsoft.com/docast/2017/07/27/sql-connectivity-troubleshooting-checklist/
https://technet.microsoft.com/en-us/library/ms187005(v=sql.105).aspx
http://sirsql.net/content/2016/11/09/availability-groups-issue-with-2016-cu2/
Leave a Reply