A connection was successfully established with the server, but then an error occurred during the login process. (provider: TLS Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Kailash Chandra Behera | Saturday, October 10, 2020

Introduction

This blog helps to fix this issue(sql a connection was successfully established with the server.....) that occurs when an application tries to open a connection to a SQL Server. In my previous blog, I have mentioned in detail why this issue occurs. To know more details about the issue visit my previous blog.

Getting Started

Microsoft has recently released some updated for different Windows OS version that contains a leading zero fixes for TLS_DHE. Meanwhile, all Windows versions that released before that do not contain the leading zero fixes. When this updated automatically installs in your computer then this type of issue occurs.

To fix this issue you need to uninstall the wiondows update and reinstall the windows update which contains the leading zero fixes for TLS_DHE.

Specially check for the Microsoft path KB4467697 in the controller panel which do not contains the leading zero fixes and uninstall it.

Steps to uninstall the Microsoft Path (KB4467697) from control panel
  1. If you are windows 10 user, direct search for control panel.
  2. Click on the control panel then click on Uninstall a program
  3. Select the patch and uninstall it.

Note: - Uninstall the windows updates that do not contains leading zero fixes for TLS_DHE, I have given the list of updates which do not contains leading zero fixes for TLS_DHE

  • Windows Server 2016, version 1607 servers that do not have the patches KB 4537806 and KB 4540670 applied.
  • Windows 10, version 1507
  • Windows 8.1
  • Windows 7
  • Windows Server 2012 R2 and earlier versions of Windows Server
Windows versions that contain the leading zero fixes for TLS_DHE
  1. Windows Server 2016, version 1607
  2. KB 4537806: February 25, 2020-KB4537806 (OS Build 14393.3542)
  3. KB 4540670: March 10, 2020-KB4540670 (OS Build 14393.3564)
  4. Updates that supersede KB4537806 and KB4540670 for the respective OS versions
  5. Windows Server 2019 RTM and later versions.
  6. Windows 10, version 1511, and later versions of Windows 10 (see release history)

Summary

I hope this content helped you understand the error and you able to sort out your problem. Again I hope that you have enjoyed it a lot.

Thanks