"Provider cannot be found" error when trying to run a MDX query?

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.  In any case if you are trying to access any remote analysis server from the local machine then ensure that your login is a member of OLAP Admin group of that particular Analsysis Services instance

Also ensure to update the ADOMD.NET driver on that client pC using this Nov2005-SQL2005_Feature pack and also refer to the SSAS_OperationsGuide for more information.