Overview
When using the Jet Excel add-in with SQL Server 2012 or higher, and testing the connection to either a NAV SQL data source or a SQL data source, a Jet Reports “Provider cannot be found. It may not be properly installed” message may be displayed.
Complete text of error: Provider Cannot be Found
Provider cannot be found. It may not be properly installed.
Cause:
This error is generally encountered when either:
- The SQL Server Native Client driver (aka “provider”) is not installed or
- The driver installed on the computer is not fully compatible with the version of the SQL Server that is being accessed.
Resolution Process
SQL Server Clients are available directly from Microsoft. Here is a link to Microsoft’s SQL Server 2012 Native Client QFE driver:
Download.
Download and install the Microsoft SQL Server 2012 Native Client QFE driver that is appropriate for your installation of Windows (X86 = 32-bit, X64 = 64-bit)
Close and restart Excel and test your report(s) again.
