One of the Business user asked for the resolution for the error they are getting when running a MDX query against the Analysis Services database within their data mart. The error is "Provider Cannot be found", before going further on this error ensure to have SQL Server client tools installed along with upto date service pack. Then connect to the Analysis Services by using Microsoft SQL Server --> Analysis Services --> MDX Sample Application and choose relevant Analysis Database on the list....(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/bi/archive/2007/11/05/provider-cannot-be-found-error-when-trying-to-run-a-mdx-query.aspx