SQL server management Studio | The client and server cannot communicate, because they do not possess a common algorithm

Article
06/16/2019

Question

_{Sunday, June 16, 2019 10:57 AM}

Hello,

I have SQL server 2016 sp2 operating under windows server 2012 r2 and i need to create linked server on another instance (SQL server 2008 SP4) operating under windows server 2008 sp2 32 bit, it was giving handshake error, i managed to enable TLS 1.0 on Server 2012 r2 and then tried to connect but it keep giving me the below message:

The client and server cannot communicate, because they do not possess a common algorithm

appreciate your help

Regads

All replies (3)

_{Monday, June 17, 2019 2:11 AM}

Hi EL-ABD,

>>The client and server cannot communicate, because they do not possess a common algorithm

This issue is related to TLS1.2 . Would you please tell me if you enable TLS1.2 both on the two servers?

SQL server 2016 sp2 operating under windows server 2012 r2 :You need to install this patch to support TLS1.2:https://support.microsoft.com/en-us/help/3154520/support-for-tls-system-default-versions-included-in-the-net-framework

SQL server 2008 SP4) operating under windows server 2008 sp2 32 bit:You need to install this patch to support TLS1.2:https://support.microsoft.com/zh-cn/help/3154518/support-for-tls-system-default-versions-included-in-the-net-framework

For more details, please refer to FIX: The encrypted endpoint communication with TLS 1.2 fails when you use SQL Server and TLS 1.2 support for Microsoft SQL Server

Hope this could help you .

Best regards,

Dedmon Dai

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

_{Monday, June 17, 2019 8:11 AM}

Hello Dedmon ,

Thanks for your support, i have applied TLS 1.2 on my windows server 2012 R2 and the other OS 2008 SP2 32 bit don't support TLS 1.2

I tried to download and install the KB you shared with me for OS 2008 SP2

(windows6.1-kb3154518-x86.msu) but it keep give me the following message :

the update doesn't apply to your system.

Please note again that my OS is 2008 SP2 not 2008 R2

Appreciate your support

_{Thursday, June 20, 2019 8:53 AM}

Hi EL-ABD,

>>Please note again that my OS is 2008 SP2 not 2008 R2

Sorry for mistaking your OS. Would you please refer to Update to add support for TLS 1.1 and TLS 1.2 in Windows Server 2008 SP2, Windows Embedded POSReady 2009, and Windows Embedded Standard 2009