title | description | ms.date | author | ms.author | ms.reviewer | ms.custom |
---|---|---|---|---|---|---|
Connection error 10054 occurs in SQL Server post upgrade |
This article provides a resolution for the 10054 error that you might experience after you upgrade SQL Server. |
05/01/2024 |
prmadhes-msft |
prmadhes |
jopilov, haiyingyu, mastewa, v-jayaramanp |
sap:Connection issues |
After a Microsoft SQL Server upgrade, you experience a connection error. The error is likely to continue even after you use the local system account for the SQL Server Agent service.
After you upgrade Microsoft SQL Server Standard Edition (STD), SQL Server Agent starts and stops immediately. Additionally, you receive one or more of the following error messages:
SQL Server does not accept the connection (error: 10054). Waiting for SQL Server to allow connections. Operation attempted was: Verify Connection on Start.
SQLServer Error: 10054, SSL Provider: An Existing connection was forcibly closed by the remote host. [SQLSTATE 08001]
SQLServer Error: 10054, Client unable to establish connection [SQLSTATE 08001]
Sometimes after a Microsoft SQL Server upgrade, TLS is disabled and you might experience a connection error. Check whether the TLS protocol is disabled after the upgrade is installed.
To resolve the error, follow these steps:
-
Enable TLS by setting the following registry entries:
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS1.0
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS1.1
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS1.2
-
Restart the computer to make sure that the change is applied.
An existing connection was forcibly closed by the remote host (OS error 10054)