Error When You Connect to OLAP After You Install SQL Server 2000 Analysis Services (282037)


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft Office Excel 2003
This article was previously published under Q282037

SYMPTOMS

In Microsoft Excel 2002 and in Microsoft Office Excel 2003, when you try to connect to an OLAP data source, you may receive an error message that is similar to the following:
Initialization of the data source failed.

Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database.
-or-

When you click Connect in the Create New Data Source dialog box, nothing happens.

CAUSE

This problem occurs when you install Microsoft SQL Server 2000 Analysis Services after you install Excel, and you then attempt to create or refresh a PivotTable Report that connects to an OLAP data source.

WORKAROUND

To work around this problem, follow these steps:
  1. In Microsoft Excel, click Detect and Repair on the Help menu.
  2. Click to clear the Restore my shortcuts while repairing and Discard my customized settings and restore default settings check boxes.
  3. Click Start.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MinorLast Reviewed:10/7/2003
Keywords:kbbug kberrmsg kbpending KB282037
©2003 Microsoft Corporation. All rights reserved.