OPENQUERY error using linked AS2005 Server

I'm not sure this may help you.

In my case, when I set linked server after enabling "allow inprocess" of
MSOLAP prover, openquery worked without object access problem.

Ohjoo


"Keith Spitz" wrote in message
news:F1643979-D041-4B07-898D-302ED9A74DB4@microsoft.com...
>I have created a linked server to an Analysis Services 2005 server using
>the
> "Microsoft OLE DB Provider for Analysis Services 9.0" provider. It
> otherwise
> uses the same settings as another linked server to an AS 2000 server using
> the "Microsoft OLE DB Provider for Analysis Services 8.0" provider.
>
> I can run an OPENQUERY from AS2000 linked server but not the AS2005 linked
> server. The error I receive using the AS2005 linked server is "OLE DB
> error
> trace [OLE/DB Provider 'MSOLAP' IDBInitialize::Initialize returned
> 0x80004005: ]."
>
> I have specified no explicit server logins, and have selected the "Be made
> using the login's current security context" option for both linked
> servers.
> This appears to turn into "NT AUTHORITY\Anonymous Login" on both remote
> servers. I have added "NT AUTHORITY\Anonymous Login" to the "Users" role
> on
> the AS2005 server database.
>
> Any thoughts or advice on making this work is appreciated.
>
> Keith Spitz
> Wall Street On Demand, Inc.