Analysis Services connectivity problems
Posted on 2004-08-18
I have Analysis Services running on a Win2K server. I can connect to the cube through Excel no problem from a PC that is physically in the same building as the server.
In another site, I log on to a PC as the same user, and I cannot now connect to the cube.
I get the 'Excel cannot find OLAP cube...' error message. However, I can connect to the server, e.g. I can use remote desktop to the server, and then log in as the same user on the server, and browse the cubes.I can also map to a share on the server and pull down files etc.
The user I am logging in as is a member of the OLAP Administrator group on the server.
Any suggestions regarding where I should start to look would be greatly appreciated!!