大网数据广告活动
数据库与应用安全

Connection error 10054 occurs in SQL Server post upgrade

· 52CE 我爱测

This article provides a resolution for the 10054 error that you might experience after you upgrade SQL Server.

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.

Symptoms

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]

Cause

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.

Resolution

To resolve the error, follow these steps:

  1. 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

  2. Restart the computer to make sure that the change is applied.

See also

An existing connection was forcibly closed by the remote host (OS error 10054)

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors (upstream author metadata: prmadhes-msft). Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 05/01/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。