I'm getting this error message when trying to connect to the database during the installation process when disabling everything but TLS 1.2 in Windows registry

*Error 27502. Could not connect to Microsoft SQL Server '(local)'. [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error. (18)*. I've tried it on SQL Server 2012 and 2016.

I'm using SQL Server Standard Edition or above and trying it in versions 2012, 2014, and 2016.

The main things I've tried so far:

Upgrading to InstallShield 2019 R3: https://docs.revenera.com/installshield26helplib/helplibrary/NewFeatureIS2019.htm

Installing SQL Server driver MSOLEDBSQL: https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

CodePudding user response：

Although I installed the driver MSOLEDBSQL, I didn't change the provider in the connection string to MSOLEDBSQL in InstallShield. Doing this and making the MSOLEDBSQL driver an InstallShield prerequisite made it work correctly.