Hi, I am trying to execute an MDX query against a SQL 2008 cube, by running a passthrough query using OPENQUERY function.
The query executes fine when running it in a MDX query window
But when running it against the linked server via OPENQUERY i receive the following error
Here is the code i used to set up the linked server, and the actual passthrough query
Any help much appreciated
I think this is the one that is solved by setting the Provider option for Inprocess.
In SSMS, go to Server Objects, Linked Servers, Providers, MSOLAP, Properties, and you should see "Allow inprocess" in the list of Provider options. Tick "Enable", and see how you go.
Like I said... I have a feeling that this is the one.
answered Jan 28, 2010 at 09:42 PM