OLE DB not supporting TLS1.2 preventing Qlikview comms with SQL server

[seanmNL1]

Hello

I have updated OLE DB on our SQL Server to allow QlikView communicate via TLS 1.2 

I believe to complete this I need to change the OLE DB connection string on the ClikView server to something like this:

Provider=MSOLEDBSQL

My question is where do I make this change? Do i make it on the Qlikview server or on the SQL Server? If it ios on the QlikView server then where on it do I make the change?

[Maria_Halley]

If the connection string has changed than you would have to change it in the script.

But in general to make TLS1.2 work you don't have to do anything on the QlikView side. 

Maria 

[seanmNL1]

Hello Maria

Do I have to make the change within each document?

I opened one of the document and then got the option to "Edit Script"

Then under the Data tab I have OLE DB listed and can hit the "Connect" button which brings up various Providers.

Which one of these should I choose?

Attached is a screenshot of my options

[seanmNL1]

Could someone come back to me on this please?

I did choose the "MS OLE DB Provider for SQL Server" and entered config details.

The "Test Connection" worked fine.

A connection script seemed to have been created. I saved the document but then the document/task failed to reload.

Please How can we resolve this please?

[Lucas_Gatling]

@seanmNL1  Can you share the document log of the QVW that is failing to reload?