Hi all,

obviously I'm not the only one with this kind of problem with linked
servers, but just to let the whole world know...

I created a linked server on a SQL Server 2005 SP1 running on Windows 2003
Server to an Analysis Services 2005 SP 1 instance on the same machine and
query it with an MDX-statement using OPENQUERY. Works fine, as long as I am
a member of the local administrators group, but when I try this as an
"ordinary" user (albeit sysadmin and member of the analysis services server
role), I get this beautiful error message:

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "MSOLAP.3" for linked server "zan_olap" reported an
error. The provider reported an unexpected catastrophic failure.

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider "MSOLAP.3" for linked server
"zan_olap".

The user can connect to SQL and Analysis Services as well. No error messages
at all in the event log, but in the SQL Server error log I can see that it
generates a stack dump:

*
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 06/13/06 18:27:48 spid 55
*
*
* Exception Address = 53A56305 Module(msdaps+00016305)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 53E91010


The minute I make my ordinary user a member of the Administrators group, it
works.

Any hints, or am I just lost in "linked server hell"?

Thanks in advance,

Markus.