SQLTeam.com | Weblogs | Forums

TCP Provider: An existing connection was forcibly closed by the remote host

We are collecting Backup Report report from all the servers using SSIS job and storing into Sql 2008R2 Server Database table.

We were able to find which servers having issue which leads to throw an error:

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Client unable to establish connection".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.

I have tried to further troubleshoot to find it out which server having issue and found that there are couple servers which are Sql Server 2017 and those are on Windows Server 2016
Both the servers which having issue had TLS 1.2 enabled for both the client and Server.
I have also disabled TLS 1.0 and 1.1.
I have also checked that Forced Encryption option in Sql server configuration and it's set up as FALSE in all those servers.
other servers which are working fine having same OS and Sql version.

Thanks for your help!