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.
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.
The latest OLE DB driver may not be the one that matches your version of SQL Server.