|
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
(comments are locked)
|
|
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. I checked the setting above, and it was already set. So i switched it off, then on, and changed my provider param for the linked server setup to "MSOLAP" rather than "MSOLAP.4", and the query now works. Thanks for the pointer !
Feb 01 '10 at 08:20 AM
David Hill
(comments are locked)
|

