Join us for SoftSummit 2023. The 20th anniversary of the industry leading software monetization conference. April 18 and 20. Register Now
When user machine has MSOLEDBSQL version higher then 18.6 version installed, below error is observed on installing the installer.
Error 27502.Could not connect to Microsoft SQL Server '(local)'. Provider cannot be found. It may not be properly installed,
This error is known to occur on using old 19.0 or above is due to windows changes introduced in latest version, you can check those changes in below shared Microsoft links
OLE DB Driver 19.0 for SQL Server
To fix this issue setup.exe with SQL script fails in MSOLEDBSQL19.0, we need to do some changes in settings.xml file,
To work with existing project:
This error is briefly documented in the InstallShield Help Library topic Troubleshooting Build Errors and Warnings.