I am trying this simple query that works fine in the MDX Sample
application.

select measures.members on columns, [Product].[Product Family].members on
rows from sales Where ( [Time].[1997] )

Here is the query in QA:
select * FROM OPENROWSET ('MSOLAP.2', 'DATASOURCE=myServer; CATALOG=FoodMart
2000', 'select measures.members on columns, [Product].[Product
Family].members on rows from sales Where ( [Time].[1997] )') AS a

Here is the error I get:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSOLAP.2' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider 'MSOLAP.2' IUnknown::QueryInterface
returned 0x80070005: Access denied.].

I have a trusted connection in QA and have full permissions to the cube.

Any help is appreciated.
Doug

Doug,
Check your permissions again. It's unlikely that this error means anything
else than "Access denied".

Jon Jahren

"Doug Stiers" <doug (AT) nospam (DOT) com> wrote

It's possible you're doing a double hop to the analysis server so
you're accessing AS under NT Anonymous and it's knocking you back.

If you're able to run the query from the SQL server itself direct to
the AS machine I would try that and see if you're getting the same
error.

Steve