topic Re: Qlik sense encrypted connection to SQL db in Connectivity & Data Prep

Qlik sense encrypted connection to SQL db

Anonymous — Mon, 04 Jun 2018 16:11:17 GMT

I am trying to use encrypted database connections to a SQL Server db.

We have installed a certificate in the SQL Server db and have the Root CA certificate also on the client from where i am running qlik sense.

when i configure qlik sense to 'trust the server certificate' i can make a successful connection to the database.

but when i un-check 'Trust Server Certificate', which should enforce a check on the client side that the certificate on the db site is valid and trusted, i get the following error:

Error message:

Please check the values for Username, Password, Host and other properties.

Description: Client unable to establish connection

Details:

ERROR[08001][Simba]Problem establishing connection to server

Anybody encountered the same issue and can help with the resolution?

Thanks for any help

Klaus

Re: Qlik sense encrypted connection to SQL db

leonardo_marmir — Thu, 14 Jun 2018 10:08:36 GMT

I encountered the same issue, but i can't help you.

I'm sorry

Re: Qlik sense encrypted connection to SQL db

Anonymous — Fri, 27 Jul 2018 11:35:35 GMT

Hi Klaus,

did you tried to create a connection with the original Microsoft ODBC driver?

Cheers!

Christian

Re: Qlik sense encrypted connection to SQL db

Anonymous — Mon, 30 Jul 2018 19:04:34 GMT

Yes, creating an ODBC connection with the sql native client and encryption works.

I would have loved to use the MS SQL facade that Qliksense provides but somewhere in the 'translation' must be an issue when using certificates. i am trying again now and get an error message with the same number but a slightly different message.

ERROR[08001][Simba]Failed verifying server credentials

Maybe the qlik team can have a look and provide a more descriptive error message that would help to resolve the issue.

Cant copy and paste from the error popup either ... just not my day today.

Re: Qlik sense encrypted connection to SQL db

CodeKazuko — Mon, 05 Sep 2022 09:20:55 GMT

Can use default snipping tool for the error if using windows.