SSL/TLS CONNECTION ISSUE

Ram Babu 45 Reputation points
2023-09-13T15:39:28.32+00:00

Hi Team,

when i run the pipeline i got error like below.

Failure happened on 'Source' side. ErrorCode=UserErrorFailedToConnectOdbcSource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.

ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.

ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.,Source=,'

But when i test connection manually, connection was success and pipeline working fine. Please advice how to avoid everytime manual test connection.

Thank you in advance

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,320 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,444 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Amira Bedhiafi 14,486 Reputation points
    2023-09-13T15:52:37.4933333+00:00

    The error you're seeing is quite specific: the source system you're trying to connect to either:

    1. Does not have SSL/TLS enabled.
    2. Or, it has SSL enabled but it's using a version lower than TLS 1.2 which your application (Azure Synapse Analytics or Azure Data Factory) is expecting.

    Given that you said you tested the connection manually and it worked fine, the issue seems to be intermittent or related to how the automated connection is initiated.

    Make sure that the source system indeed has SSL enabled and is using TLS 1.2 or higher. If it's a database, you might need to consult its documentation or work with your system administrator.

    Sometimes, the way the connection string is formatted or the parameters included can cause issues. Make sure the connection string used in your pipeline matches the one you're using manually.

    If you're using a Service Principal for the pipeline, ensure it has the necessary permissions to the source system and that its credentials haven't expired.

    It's possible for transient network issues to cause these kinds of errors. Though, if this is the cause, the error would be intermittent.

    0 comments No comments

  2. QuantumCache 20,026 Reputation points
    2023-09-13T21:09:37.3566667+00:00

    Hello @Ram Babu Thanks for reaching out on this forum.

    Could you please specify which Azure Resource is involved here?
    Is it Azure Data Factory's Pipeline or Data Flow?

    Is it Azure Synapse Pipeline?

    Could you please add any screenshots of the error from the pipeline if possible?

    Please let us know how was the connection established from the linked Service?

    User's image

    User's image

    Looks like you are not using any SHIR (Self Hosted IR), or Private endpoints, right?

    --as asked by Amira in previous comment!

    Also please check what do you see in the login history of the user on the Salesforce side, when the error encountered with ADF pipeline?
    The login history on Salesforce side will give more details about the TLS...
    User's image

    0 comments No comments