Using the Internet, you can communicate with people from different countries irrespective of their location with the help of a secure set of protocols. However, sometimes you may encounter some Windows errors on your PC when one of the protocols fails to work correctly. The blog focuses on the causes and resolution of “An existing connection was forcibly closed by the remote host” Windows error that may appear when one of the key protocols fails to work on your computer.
A protocol is a bundle of rules that any running application on your PC must follow for a safe and secure Internet connection. If any application is not following these set of rules or protocol, then you may start facing trouble with the application. You may get some error messages while opening, using, and closing the application.
“An existing connection was forcibly closed by the remote host” is one of the Windows errors that may appear because of multiple reasons on your PC. In the current blog, you will find out that how the error occurs when an application on your PC fails to meet the requirement to establish a secure connection.
Understanding the Error Symptoms
On Windows XP, or Windows 2000 PC, you may receive certain errors when you try to connect to the Microsoft SQL Server 2005 instance using different protocols. If you are connecting to the instance with the help of TCP/IP protocol, then you may get the following error message:
“An existing connection was forcibly closed by the remote host.”
Cause of the Error
The error occurs when the SQL Server service loads a certificate with AT_SIGNATURE key specification for Secure Sockets Layer (SSL) encryption of the instance. In SQL Server 2005, you can’t use a certificate with AT_SIGNATURE key specification for SSL encryption. In other Windows versions such as Server 2003, the certificate gets recognized as invalid. On the other hand, when you use Windows XP or Windows 2000 PC, the certificate gets loaded and starts successfully thus causing a connection failure.
What Should You Do?
When you see the error message, you can either search the web to explore the PC troubleshooting tips from computer experts, or seek some quick assistance from your computer tech guy. If your tech guy is not available, then you can also visit your nearest computer store, or contact an online computer support partner to correct all your PC issues. If you don’t wish to spend your money on a technician, then you can also try to perform the troubleshooting steps present in the next section.
Expert Troubleshooting Tips for Your Computer Repair
The error appears when the certificate with AT_SIGNATURE key specification gets loaded for SSL encryption. Therefore, you should use the valid certificate with AT_EXCHANGE key specification to fix the computer problem.
As stated earlier, your issue may get fixed with the use of a valid certificate. However, you should also know how to check the key specification of a certificate. These steps will help you to obtain the key specifications using Certutil utility (Certutil.exe) on your Windows XP or Windows 2000 PC:
- Press and hold ‘Windows’ key, and then press letter ‘R’ key to launch the ‘Run’ dialog box.
- In the ‘Run’ dialog box, type ‘cmd,’ and then click ‘OK.’
- In the ‘Command Prompt’ window, type “regedit.exe” command and then press ENTER on your keyboard to open the Registry Editor.
- In the Registry Editor window, try to locate the “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib” registry subkey to obtain Certificate’s registry key value.
- In the subkey, locate the following section to identify the key specification:
Note: The value ‘1’ next to ‘KeySpec’ indicates a valid certificate. If the value next to ‘KeySpec’ is ‘2,’ then it indicates the presence of certificate with the AT_SIGNATURE key specification.
- After identifying the key specification, go back to the ‘Command Prompt’ window, and type “Certutil -store -v my –CertificateSerialNumber” command, and then press ‘ENTER’ on the keyboard.
Here, ‘CertificateSerialNumber’ is the certificate’s serial number that you obtained in earlier steps.
Using the valid certificate will help you to fix your PC issue. However, you need to be cautious while locating the subkey in the PC registry as mistakenly locating and modifying a subkey may cause computer crash or system failure.
Conclusion
The current blog features only a single reason for the occurrence of “An existing connection was forcibly closed by the remote host” error on a Windows device. The same error message may also appear because of some other reasons. You may fix some of them using the troubleshooting tips from different computer tech experts. However, there may be certain error conditions that would need assistance from a live technician. Therefore, you can either reach your nearest PC repair shop or connect to an online computer support person who can handle all these situations with ease.