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.
Looking to simplify financial reporting in Excel?
👉 Join our Jet Reports Training and learn to create real-time, dynamic reports with confidence.
👉 Join our Jet Reports Training and learn to create real-time, dynamic reports with confidence.
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.
