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

17 January,2017 by Jack Vamvas

Question : A user contacted me with an error message on a newly installed SQL Server Management Studio. The error message appeared while using the Import Data Wizard on Excel, connecting a SQL Server and extracting the data.

Microsoft ACE OLEDB 12.0 provider is not registered on the local machine (System.Data)

Ms_ace_oledb

 

How can I fix this issue?

Answer: This is not strictly a SQL Server Database Engine problem. The error is related to the installation of SQL Server Management Studio.

The prerequisite for Microsoft Access Database Engine 2010 is missing. Microsoft Office or the free Microsoft Access Database Engine redistributable installed for the correct architecture of the machine.

Read More

Top 4 Best SQL Editors (SQL Server DBA)

SQL Server - Open SSMS on the Command Line (SQL Server

SQL Server – Hover mouse over "*" sql statement to view all

 

 

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Microsoft ACE OLEDB 12.0 provider is not registered on the local machine


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer