I'm using linked server to SSAS that running on same machine.
usually the linked server is working just fine, but from time to time I get this error:
Cannot create an instance of OLE DB provider "MSOLAP" for linked server "SALES_CUBE". (Microsoft SQL Server, Error: 7302)
restarting the SQL fix the problem till the next time.