TLS 1.2 support in IS 2018 ?

[vivekjazzwal]

Hi,

Does Installshield 2018 support TLS 1.2 environment where i can execute sql scripts using "SQL scripts" feature of InstallShield ?

[Roman1]

Update

https://support.microsoft.com/en-us/help/3140245/update-to-enable-tls-1-1-and-tls-1-2-as-default-secure-protocols-in-wi/

[vivekjazzwal]

Larry578 wrote:
we are in same boat. please help me, if you find any thing related to this query. and I also not able to update TLS 1.1 to TLS 1.2. Suggest me how can I do this?

Hi Larry,

If you are using setup.exe, you can add a new pre-requisite for installing Microsoft latest MSOLEDBSQL driver and update the AdoDriverName coumn to 'msoledbsql' in ISSQLDBMetadata table.This should fix issue for TLS 1.2 and later environments.

Let me know if you find any other alternatives..

[NikhilPatel]

Hi Vivek,

I tried what you suggested but it didn't work. I am using Install shield 2020 R3 and MSSQL server to connect. Do you have any alternate solution which may work

[harold_olsen1]

vivekjazzwal wrote:
Hi Larry,

If you are using setup.exe, you can add a new pre-requisite for installing Microsoft latest MSOLEDBSQL driver and update the AdoDriverName coumn to 'msoledbsql' in ISSQLDBMetadata table.This should fix issue for TLS 1.2 and later environments.

Let me know if you find any other alternatives..

The solution we used (in IS2015) was to direct edit the SQLServer ISSQLDBMetaData from the oledb driver to the newer driver "sqlncli11". The line should look like:
MSSQLServerMicrosoft SQL Serversqlncli11 ....
We had to manually insure the right version of the native driver because the IS pre-req version wasn't adequate..