i have the following problem:

i want to connect to a OLAP-Cube fon aSQL Server 2005 September CTP. i try
to connect to the cube in this configuration:

Win XP Professional english
Excel 2003 english SP2
OLE-DB driver for Analysis Services 9.0 english

When i try to connect to the OLAP-Cube via the Pivot-Chart, i get the
follwoing error "an error was encountered in the transport layer"

when i try on a computer with the same constellation exept the operationg
system, who is windows Server 2003 english, the acces to the cube worked

has anyone a idea?

Is your Windows XP box connecting to another box which contains the OLAP
cubes? One possibility is that when you are using Windows XP, the firewall
within it may be causing communication issues whether it is to connect to
another box or even to itself. The ports to open are:
For Yukon (SQL Server 2005), you will need to open as well:
Analysis Services 2005: 2383 (default port), 2382 (redirector port)


--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>
space: http://spaces.msn.com/members/denster/




"Bernd" <Bernd (AT) discussions (DOT) microsoft.com> wrote

The Server with the OLAP-Cube is a windows 2003 Server. I disabled the
firewall for my tests on the XP-client. Now i enabled the firewall and tried
your settings, but the error message is the same

"Denny Lee" wrote:

i too have this issue! Any ideas?! Interestingly (I think) I only got this
error after manually registering msolap90.dll as mentioned in a previous post
as before doing that I got a different error message!
--
Simmo


"Bernd" wrote: