I am having a problem using getting the databases from our SQL Analysis Server 2000 using the Microsoft OLE DB Provider for OLAP Services 8.0 driver. I can view all the databases using the Analysis Manager; however, when Microsoft Query attempts to open view the databases I get no databases to select.
This is the click by click order of what I am doing:
From Excel, Selecting the Data menu -> PivotTable and PivotChart Report. I am selecting "External data source" and leaving PivotTable selected. I click Next then select the "Get Data..." button. When the "Choose Data Source" window appears I am selecting the "OLAP Cubes" tab then selecting "<New Data Source>". At this point I am presented with the "Create New Data Source" window. I enter a name then select "Microsoft OLE DB Provider for OLAP Services 8.0" from the provider drop-down. I then click "Connect..." to receive the "Multidimensional Connection" wizard. I leave "Analysis server" selected and enter the name of my Database server (just so happens to be named "DATA"). I am not entering any login details as the Database server is on the same LAN as my PC and there is no firewall between the two boxes. I click Next and receive a list-box with only a grayed out "(No databases available)".
Any assistance anyone would lend would be beneficial.