Error 27502.Could not connect to Microsoft SQL Server '(local) Using MSOLEDBSQL 19.0'
Summary
When user machine has MSOLEDBSQL version higher then 18.6 version installed, below error is observed on installing the installer.
Symptoms
Error 27502.Could not connect to Microsoft SQL Server '(local)'.
Provider cannot be found. It may not be properly installed,
Cause
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
Resolution
To fix this issue setup.exe with SQL script fails in MSOLEDBSQL19.0, we need to do some changes in settings.xml file,
- Go to Installshield installed location and Open settings.xml from below path
- C:\Program Files (x86)\InstallShield\2021\Support\0409
- Edit the file named settings.xml using notepad or notepad++, go to line number 296 or search name IS_MetaData
- And set the value for MetaDataName like shown below
<IS_MetaData Name="MSSQLServer" DisplayName="Microsoft SQL Server" - we also need to set the provider like shown below
AdoCxnDriver="Provider=MSOLEDBSQL19.1" - and next in the same line we need to change AdoCxnAddtional as shown below
AdoCxnAdditional="Use Encryption for Data=False" - Then Save the Settings.xml file and close Installshield and Reopen Installshield
-
NOTE: We need to Create the project to see the changes for existing projects this changes wont affect,
To work with existing project:
- Open Existing project with SQL script added.
- Then go to Direct Editor and select ISSQLDBMetaData table and delete the existing row.
- Go to SQL Script view
- Add a new SQL script OR delete and re add your SQL script view
- After adding SQL script
- Go to direct editor and check ISSQLDBMetaData table
- Check values are added like shown below, this 2 values are important, if its not added it wont work
- Then save your project and build
- Install it a machine where OLDDBSQL 19.0 or higher version is installed, now the setup.exe will work as expected.
Additional Information
This error is briefly documented in the InstallShield Help Library topic Troubleshooting Build Errors and Warnings.
Related Articles
Error 27502. Could Not Connect To Microsoft SQL Server Using TLS 1.2 (Transport Layer Security 1.2) 134Number of Views Microsoft data link error when connecting to SQL server in Business Adapter Studio 20Number of Views Recognizing Microsoft SQL Server installations using Deployment Manager and Enterprise Compliance Manager 10Number of Views Scan Microsoft SQL Server PowerShell script overview 8Number of Views Microsoft SQL server editions can't be determined correctly from SCCM 17Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago