Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 748
  • Last Modified:

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!!
0
BillAn1
Asked:
BillAn1
1 Solution
 
BillAn1Author Commented:
OK, I sorted the problem out!
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.
0
 
RomModCommented:
The question has been PAQ'd and the 500 points have been refunded.
RomMod
Community Support Moderator
0
 
BoltonWandererCommented:
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
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now