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

[PadmaPriya]

Environment:

Qlik Sense Enterprise on Windows 

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:

1. Open SQL Server Configuration Manager.
2. Expand SQL Server Network Configuration.
3. Select the Protocols for <instance name>.
4. Right-click and select Properties.
5. Click the Certificate tab.
6. Click View, and view the cert details.
7. Click the Details tab.
8. 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.