run openquery(mdx) through a linked server

Hi,

I run openquery() from a client application(sql 2005) to query SSAS data(sql 2005) through a linked server(sql 2005), but I get the following error:

OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "An error was encountered in the transport layer.".
OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "The peer prematurely closed the connection.".
Msg 7303, Level 16, State 1, Procedure gettpdt, Line 3
Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "LINKEDMINING".

And, I am sure that I have made the MSOLAP provider Allow inprocess.

What can i do for this. Please advise.

Can you connect to Analysis Services directly from SQL Server management studio, from the same machine as SQL Server?|||

hi,

I have solved this problem, thank you

|||how did you solve it?|||How did you solve this problem?|||

add the server as trusted server in Active Director

choose the option 'trust computer for delegation'