Error "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" on x64 systems

Products

• IT Management Suite
• Client Management Suite
• Server Management Suite

Issue/Introduction

When creating a Data Connector Data Source using an excel spreadsheet (.xls or .xlsx), the following error is seen.

"The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine"

Environment

ITMS 8.x

Cause

The .dll mentioned in the error must be registered on the Notification Server (NS).  This .dll is installed with Office 2010 and later but must be the x64 edition of MS Office when installed on a 64-bit server.

Resolution

There are two methods to resolve this issue.

• Install MS Office 2007 x64 or later x64 version of MS Office. 
• Alternately Microsoft provides an executable that will install the needed files without the need to install MS Office on the SMP.   Note: In the event that the download location becomes unavailable the name of the file is Access Database Engine 2010 Redistributable and could be searched on Microsoft's download site.