MS SQL Server OLAP - OpenQuery connection failed

Author

OpenQuery connection failed

esl

2006-03-23, 1:32 pm

Hi all,

I want to query a cube stored in AS2005 from SQL2005 database engine.
Both are on the same box.
My statement is a basic select * from openquery(...) and everything
works fine... but only if I run the query on the server.

As soon as I try from another client box I've got the following
message:
"An error was encountered in the transport layer."
"The peer prematurely closed the connection."

Both server/client are on the same domain and my user has rights on it.
Firewalls have been disabled for test.

Something is interesting to notice: when I change the status of the
firewall (enable/disable) my error message changes for the first
execution only and becomes:
"The physical TCP/IP connection failed: An existing connection was
forcibly closed by the remote host"
"The peer prematurely closed the connection."

Another important element: My server is a W2003 R2 (64 bits)
May the problem comes from 64 vs 32 bits ?

btw I've enabled TCP/IP in the configuration tool.
Thanks in advance for any idea !

Eric

Sponsored Links