This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
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!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Hi,
According to the error message, this looks like a TLS issue. Please check the TLS 1.2 support for Microsoft SQL Server
Thanks Criszhan.
I am also thinking same but couldn't find the exact cause as i have checked both the troublesome servers having TLS 1.2 enabled for client and Server protocol in the registry and i have also checked other server which is running fine and having same Sql 2017 installed on Windows Server 2016.
Hi,
Is this SSIS job running on Sql 2008R2 Server?
can you get any error message like " “Login failed for user..." from the Errorlog of the servers which have issues.
Thanks Criszhan.
It's DTS package.
We didn't see any login failed error.
It's strange that We have exactly same TLS 1.2 setting on other servers and others server which are working fine having same OS and Sql version.
Hi,
Check the differences in SQL Server instance level settings. Open the SQL Server Configuration Manager, check the properties of instance: "Force Encryption".
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.
Thanks Sreekanth for looking into the issue.
Do you know what kind of certificate?
Sreekanth,
Service running only for the Sql server and Agent.
Sreekanth,
Any further solution as today i have also checked Force Encryption option in Sql server configuration and it's set up as FALSE in all those servers. So i believe there are no certification.