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

Local SQL Server can't connect to a linked server when RSA encryption is used

· 52CE 我爱测

This article provides a resolution for an error that prevents a client computer from connecting to the linked server.

This article helps you resolve an error in Microsoft SQL Server that prevents a client computer from establishing a connection with a linked server.

Symptoms

You might receive the following error message if there's a mismatch in encryption settings both on the client and server:

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

Cause

The 10054 error might occur in the following situations:

  • If the SQL Server certificate uses RSA to encrypt the public key but cipher suites for the client and server differ.

  • If RSA is disabled on the server.

Resolution

To resolve this error, modify the following registry key value on the server to enable RSA:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\KeyExchangeAlgorithms\PKCS] "Enabled"=dword:0xffffffff

Note: You must restart the server for the change to take effect.

Enabling RSA encryption on the server usually doesn't create any security risk for your environment.

For more information about the Transport Layer Security (TLS) and RSA configuration, see Restrict cryptographic algorithms and protocols.

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 04/18/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

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

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