How to configure QlikView to use TLS 1.2

[seanmNL]

Hello

Our QlikView version is 12.0.20500 SR6 which I believe supports TLS 1.2

For security reasons we disabled TLS 1.0 but this seems to caused Qlikview jobs to fail with no data being pulled into Qlikview.
How do we make our Qlikview use TLS 1.2 ?

TLS 1.2 is enabled in the registry and in Internet Explorer

Do we need to make changes within the configuration of Qlikview to use TLS 1.2 and how do we do this?

Thanks

Sean

[seanmNL]

nope

[Chip_Matejowsky]

Hi @seanmNL,

In QV Desktop, can you use the File > Open menu and browse to the Source Documents directory to open one of the QVWs in order to enable Document logging?

Best Regards

[seanmNL]

Hi Chip - so I went in and open each document and enabled the Logs. Here is the log from one that failed:

[seanmNL]

2021-05-20 16:50:23 Execution started.
2021-05-20 16:50:23 QVB Version 12.0.20500.0
2021-05-20 16:50:23 CPU Target x64
2021-05-20 16:50:23 Operating System Windows Server 2016 Standard (64 bit edition)
2021-05-20 16:50:23 Wow64 mode Not using Wow64
2021-05-20 16:50:23 Language 1809 English (Ireland) English
2021-05-20 16:50:23 Country 353 Ireland Ireland
2021-05-20 16:50:23 MDAC Version 6.3.9600.16384
2021-05-20 16:50:23 MDAC Full Install Version 6.3.9600.16384
2021-05-20 16:50:23 PreferredCompression 2
2021-05-20 16:50:23 EnableParallelReload 1
2021-05-20 16:50:23 ParallelizeQvdLoads 1
2021-05-20 16:50:23 AutoSaveAfterReload 0
2021-05-20 16:50:23 BackupBeforeReload 0
2021-05-20 16:50:23 EnableFlushLog 0
2021-05-20 16:50:23 SaveInfoWhenSavingFile 0
2021-05-20 16:50:23 UserLogfileCharset 65001
2021-05-20 16:50:23 OdbcLoginTimeout -1
2021-05-20 16:50:23 OdbcConnectionTimeout -1
2021-05-20 16:50:23 ScriptWantsDbWrite false
2021-05-20 16:50:23 ScriptWantsExe false
2021-05-20 16:50:23 LogFile CodePage Used: 65001
2021-05-20 16:50:23 UseMemoryFillPattern 1
2021-05-20 16:50:23 ScriptMode Legacy (gives greater system access) (aka qv11 mode)
2021-05-20 16:50:23 ReloadCodebase Classic
2021-05-20 16:50:24 Reload Executed By EU\qlikview
2021-05-20 16:50:24 Process Executing QVB
2021-05-20 16:50:24 Process ID 13200
2021-05-20 16:50:24 0002 SET ThousandSep=','
2021-05-20 16:50:24 0003 SET DecimalSep='.'
2021-05-20 16:50:24 0004 SET MoneyThousandSep=','
2021-05-20 16:50:24 0005 SET MoneyDecimalSep='.'
2021-05-20 16:50:24 0006 SET MoneyFormat='€#,##0.00;-€#,##0.00'
2021-05-20 16:50:24 0007 SET TimeFormat='hh:mm:ss'
2021-05-20 16:50:24 0008 SET DateFormat='DD/MM/YYYY'
2021-05-20 16:50:24 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'
2021-05-20 16:50:24 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2021-05-20 16:50:24 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2021-05-20 16:50:24 0014 OLEDB*CONNECT32*Provider*OLEDB*
2021-05-20 16:50:56 Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.
2021-05-20 16:50:56 General Script Error
2021-05-20 16:50:56 Execution Failed
2021-05-20 16:50:56 Execution finished.

[Lucas_Gatling · Accepted solution]

@seanmNL  see this article pertaining to the error message you are getting in the document logs:

https://community.qlik.com/t5/Knowledge-Base/SSL-Security-error-using-Microsoft-OLE-DB-Provider-for-...

[seanmNL]

Thats great thanks Lucas. This is something that I'll have to consider fixing carefully as the other server is a SQL server - cheers