Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #145: Cannot communicate, because they do not possess a common algorithm

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Nov 23, 2020

Today, I saw a new service request that our customer is trying to create a linked server but they faced the following error message: SSL Provider: The client and server cannot communicate, because they do not possess a common algorithm. OLE DB provider "MSOLEDBSQL" for linked server "servername" returned message "Client unable to establish connection". (.Net SqlClient Data Provider)"

 

From March 2020, Azure SQL Managed Instance enforces  to use TLS 1.2 protocol for outbound connections. In this link you could find the reason and also a fix.

 

 

Published Nov 23, 2020
Version 1.0

1 Comment

Sort By
  • Manjunath_U's avatar
    Manjunath_U
    Copper Contributor
    Mar 22, 2021

    Hi

     

    I am getting the below error when connecting SQL server. Enabled TLS 1.2 and disabled 1.0 and 1.1.

     

    Below is the version information. Can you please suggest. How to resolve it?

     

    SQL Server Management Studio 15.0.18369.0
    SQL Server Management Objects (SMO) 16.100.46041.41
    Microsoft Analysis Services Client Tools 15.0.19342.0
    Microsoft Data Access Components (MDAC) 10.0.19041.1
    Microsoft MSXML 3.0 6.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.19042

     

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to CIHCTSVDBSQA289.logon.ds.ge.com\PROD.

    ------------------------------
    ADDITIONAL INFORMATION:

    A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.) (Microsoft SQL Server, Error: -2146893007)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&Evtsrc=MSSQLServer&EvtID=-2146893007&LinkId=20476

    ------------------------------

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

    ------------------------------
    BUTTONS:

    OK
    ------------------------------