Who is this article for?

IT personnel performing a Ideagen Quality Management upgrade.

IT access will be required to implement this update.

Ideagen Quality Management 7.1.6 introduces bug fixes and feature updates, including changes to how TLS is used. The TLS change has also updated the pre-requisites of the application. If the pre-requisites have not been installed then you will experience this error:

Error 27502. Could not connect to Microsoft SQL Server. Provider cannot be found. It may not be properly installed.

This article outlines how to resolve the issue and is split into the following sections:

1. How to Fix Provider Cannot be Found
   • How to Check if Microsoft OLE DB Driver Is Installed
   • How to Install Microsoft OLE DB Driver
2. Further Reading

1. How to Fix Provider Cannot be Found

This error occurs as a result of the TLS changes included in the 7.1.6 update. These changes require a pre-requisite SQL component (Microsoft OLE DB Driver) to be installed. This may already be installed in your environment, however if you are using Microsoft SQL Server 2017 or lower then you may need to install this in order to continue with the upgrade.

Need more information on the changes? Visit Ideagen Quality Management 7.1.6 Release Notes for more details.

To check if Microsoft OLE DB Driver is installed:

1. Press Start.
2. Launch Control Panel, then Program and Features.
3. Search for 'Microsoft OLE DB Driver for SQL Server'.
4. If the Microsoft OLE DB Driver is not listed then you will need to install it.

To install the Microsoft OLE DB Driver

1. Open the Ideagen Quality Management installation media.
2. Browse to SMO Version 10 folder.
3. Run msoledbsql.msi
4. Follow the on-screen instructions.
5. Once complete, run the Ideagen Quality Management Server install wizard again.

2. Further Reading

• Ideagen Quality Management 7.1.6 Release Notes
• How to Perform a Ideagen Quality Management 7 Upgrade