Local SQL Server can't connect to a linked server when RSA encryption is used
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)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tijekom 2024. postupno ćemo ukinuti servis Problemi sa servisom GitHub kao mehanizam za povratne informacije za sadržaj i zamijeniti ga novim sustavom za povratne informacije. Dodatne informacije potražite u članku:Pošaljite i pogledajte povratne informacije za