Problem
When installing or updating Informant, particularly on older versions of Windows Server, you may get the following error:
Informant cannot be installed or updated on this machine because a required component is missing.
Please install the latest version of the Microsoft OLE DB Driver for SQL Server (MSOLEDB) from Microsoft's website first.
After installing the driver, re-run the setup program to complete the Informant installation/update.
The setup program will now exit.
Cause
Some versions of Windows do not have the correct SQL Server driver for Informant. A specific version of the driver is required when SSL 3.0 is disabled and TLS 1.0 is enabled in Windows, as older versions of the driver don't support the TLS 1.0 protocol, and some newer versions of the driver are not compatible with Informant.
Resolution
- Download version 18.3 of the Microsoft OLE Driver for SQL Server:
- If you are running a 64-bit version of Windows: Download msoledbsql for 64-bit Windows
- If you are running a 32-bit version of Windows: Download msoledbsql for 32-bit Windows
- Run the downloaded installer for the driver. Note that this may require you to restart the server, so be sure to inform your users and make sure the server can be safely rebooted.
- Re-run the Informant setup program. The setup should now complete without errors.