Qlik Sense - Unable to connect to SQL servers configured to use encrypted connections

PadmaPriya — Tue, 10 May 2022 19:15:54 GMT

Environment:

Microsoft SQL Server

Problem:

The Test Connection option fails when you try to configure Qlik Sense to connect to an SQL Server.

When the test fails, the following error message displays:

Test Failed: Network IOException: certificate_unknown(46)

The above occurs when the SQL Server is configured to use a custom certificate for its connections.

Cause:

The cryptography provider requires the certificate that the SQL Server uses to have the Digital Signature parameter set under the Key Usage field. If the certificate used by your SQL Server does not have this parameter set, the error occurs.

To validate the issue:

Open SQL Server Configuration Manager.
Expand SQL Server Network Configuration.
Select the Protocols for <instance name>.
Right-click and select Properties.
Click the Certificate tab.
Click View, and view the cert details.
Click the Details tab.
Click the Key Usage field and validate whether Digital Signature is present or not.

Solution:

Configure your SQL Server to use a certificate that has Digital Signature enabled under Key Usage.
NOTE: It might be required to restart the SQL Server after you change the certificate.

article Qlik Sense - Unable to connect to SQL servers configured to use encrypted connections in Official Support Articles

Qlik Sense - Unable to connect to SQL servers configured to use encrypted connections

Environment:

Problem:

Cause:

Solution: