Hi,
According to the error message, this looks like a TLS issue. Please check the TLS 1.2 support for Microsoft SQL Server
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
We are collecting Backup Report report from all the servers using SSIS job and storing into Sql 2008R2 Server Database table.
We have Full Backup nightly job which is running on the all servers and we are capturing these backup infor from all the servers and storing in to table which we retrieve information regarding Backup details so we know whcih server having backup issue or not.
Another job collecting the data from the table and send us an email if which server having issue that not run the backup.
We are facing currently issue that job is unable to collect the couple of servers and throwing following 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.
Thanks for the help!
Hi,
According to the error message, this looks like a TLS issue. Please check the TLS 1.2 support for Microsoft SQL Server
Do you have services running on the server?
If so does it have any certificate installed for SQL? then validate the certificate expiry. That would also cause the issue.