Symptoms
When attempting to set OLAP security in the Jet Data Manager, or when attempting to connect to a SQL Server Analysis Services database from Excel you may receive the following error:
Provider cannot be found. It may not be properly installed.
Resolution
To resolve this error you will need to install the latest OLE DB diver for SQL Server Analysis Services on the machine you are working with. This download can be found on the Microsoft website.
More detailed information regarding how to obtain the latest OLE DB Provider can be found here: How to obtain the latest versions of MSOLAP
The latest OLE DB driver may not be the one that matches your version of SQL Server.
Comments