Error: Test connection failed - SSL Security error RRS feed

  • Question

  • Hi,

    I am trying to run a SSIS package on Windows server 2016 with SQL server 2016 installed (MDS 2016) . However, the job is getting failed.

    I found that the connection manager is unable to connect to the server for provider : Microsoft OLE dB provider for SQL server with windows authentication and gives the below error :

    Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

    I have tried the below fixes:

    1) Enabling TLS 1.0

    2) .NET framework 4.0

    3) Enable SSL 3.0

    4) windows firewall enabled

    However, the error is persisting. This issue is not shown in SQL Server 2012.

    I had SSL2/3, TLS1.0/1.1 disabled and only TLS1.2 enabled

    How to fix this?


    • Edited by Venkatzeus Friday, June 29, 2018 11:37 AM
    Friday, June 29, 2018 10:50 AM