Import data to Excel 2013 from SQL Server 2014 with TLS 1.0 disabled


  • Hello

    I have SQL Server 2014 Standard SP2 x64 (12.0.5511.0) on one vm (Windows Server 2012 R2). On the second vm (same OS) I have Excel 2013. Recently TLS 1.0 has been disabled on all servers and user can't import data from SQL. 

    While filling Data Connection Wizard he is receiving following error:

    [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

    Do you know what have to be done to make it working again?


    Thursday, January 19, 2017 1:18 PM

All replies