Thursday, March 22, 2012

Accessing Cube from Excel 2003

Analysis services Cube is created using SQL Server 2005 (CTP June). Server is in Prod domain.
There is no problems accessing and playing with Cube in the same box or within PROD domain.

While trying to access Cube from excel 2003 from a computer in other domain QUAL gives the following error

"an error was encountered in the transportation layer"

Any suggestions ?

I'm not exactly sure how IE Security settings interact with PTS, but your problem is making me think of the 'Access Data Sources across Domains' option in IE / Tools / Options / Security / Custom Level / Misc.

Is that option enabled?

No comments:

Post a Comment