Encryption not supported on the client error in QlikView

Raju_6952 — Mon, 02 Sep 2024 09:12:10 GMT

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

Re: Encryption not supported on the client error in QlikView

mpc — Mon, 02 Sep 2024 20:49:06 GMT

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

topic Encryption not supported on the client error in QlikView in Connectivity & Data Prep

Encryption not supported on the client error in QlikView

Re: Encryption not supported on the client error in QlikView