BillAn1
asked on
Analysis Services connectivity problems
Hi,
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!!
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!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi BillAn1 - I have exactly the same problem on one pc on our network.
Can you tell me where you get the 2000 driver provider?
Cheers
Chris
Can you tell me where you get the 2000 driver provider?
Cheers
Chris
ASKER
The issue was that the client PC was using Excel2000. By default, Excel2K comes with the driver for SQLServer7.0 OLAP provider, but not SQLServer 2000. Normally, there is no problem, the 7.0 Driver can connect to a 2000 cube etc. However, the cube in question had a parent-child dimension. When this is used, the cube is no longer 'visible' to Excel, using the 7.0 Driver.
To confuse the issue, the first client PC I went to did have the same version of Excel, but at some stage somebody had installed the more up-to-date drivers.