PRB: OLAP Cubes in an Analysis Services Database Are Not Accessible After You Apply Analysis Services SP3 (829747)


The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services SP3
  • Microsoft Office XP

SYMPTOMS

When you install Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3) on an Analysis Services computer, and then you connect to or query the Analysis Services database from another computer by using a Microsoft Office XP client application (such as Microsoft Excel 2002), the OLAP cubes in the Analysis Services database may not be accessible. The OLAP cubes in the Analysis Services database are not listed when you connect to the database by using the Office XP client application.

CAUSE

Office XP includes Microsoft PivotTable Service (Msolap80.dll) version 8.0.323. This version of the PivotTable Service client cannot access the OLAP cubes in an Analysis Services database that runs SQL Server 2000 Analysis Services SP3. The version of the Msmdsrv.exe file that is installed with SQL Server 2000 Analysis Services SP3 is 8.0.760. The problem occurs because the client application and server application are not compatible.

RESOLUTION

To resolve the problem, install the SQL Server 2000 PivotTable Service application that is included in SQL Server 2000 Analysis Services SP3 on the computer that is running the Office XP application. To do so, follow these steps:
  1. Connect to the SQL Server 2000 Analysis Services SP3 Setup folder.
  2. Under the SQL Server 2000 Analysis Services SP3 Setup folder, locate the Msolap\Install\Pts folder.
  3. To install SQL Server 2000 PivotTable Services, run Ptslite.exe or Ptsfull.exe.

    Note Ptslite.exe only installs the PivotTable Service files. Ptsfull.exe installs the PivotTable Service files and Microsoft Data Access Components (MDAC).
  4. Follow the instructions in the SQL Server 2000 PivotTable Service Setup Wizard to complete the installation of SQL Server 2000 PivotTable Service.

MORE INFORMATION

Steps to Reproduce the Problem

To reproduce the problem, follow these steps:
  1. Start Excel 2002.
  2. Create a new blank workbook.
  3. On the Data menu, click PivotTable and PivotChart Report.
  4. In the PivotTable and PivotChart Wizard - Step 1 of 3 dialog box, click the External data source option, and then click Next.
  5. In the PivotTable and PivotChart Wizard - Step 2 of 3 dialog box, click Get Data.
  6. In the Choose Data Source dialog box, click the OLAP Cubes tab.
  7. In the Data Sources list box, double-click <New Data Source>.
  8. In the What name do you want to give your data source? text box, type FoodMartPTSTest.
  9. Click Microsoft OLE DB Provider for OLAP Services in the Select an OLAP provider for the database you want to access list, and then click Connect.
  10. In the Multi-Dimensional Connection dialog box, click the OLAP Server option.
  11. In the Server text box, type the Analysis Services computer name, and then click Next.
  12. In the Database list, click FoodMart 2000, and then click Finish.

    Note The Select the Cube that contains the data you want list may not list any OLAP cubes from the FoodMart 2000 database.
  13. In the Choose Data Source dialog box, click OK.
  14. In the PivotTable and PivotChart Wizard - Step 2 of 3 dialog box, click Next.
  15. In the PivotTable and PivotChart Wizard - Step 3 of 3 dialog box, click Finish.
Modification Type:MajorLast Reviewed:11/25/2003
Keywords:kbsetup kbwizard kbServer kbDatabase kbprb KB829747 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.