Encryption not supported on the client error in QlikView

[Raju_6952]

Hi ,

We are getting below mentioned error while loading data from Sql database using ODBC connection established.

(8/30/2024 1:40:30 PM) Information: 0016 ODBC CONNECT TO *** (XUserId is ***, XPassword is ***)

(8/30/2024 1:40:30 PM) Information:      Error: Connector connect error: SQL##f - SqlState: 08001, ErrorCode: 21, ErrorMsg: [Microsoft][SQL Server Native Client 11.0]Encryption not supported on the client.

(8/30/2024 1:40:30 PM) Information:      Execution Failed.

Any Suggestions would be highly appreciated for fixing this issue.

Regards,

Raju

[mpc]

Hi, 

It's seem that QlikView serveur and MSSQL one do not have common encryption algorithm. 
Often, TLS 1.0 is disblabed on the QlikView machine, (because it's deprecated) and the server cannot handle this. 

You can try to apply recommanded settings with IISCrypto on both machine, and/or install the ODBC Driver in line with your SQLServer version. 

Kind regards