OPENQUERY error using linked AS2005 Server

[Database Administrator]

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.

[Database Administrator]

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.