Microsoft KB Archive/282037

= Error When You Connect to OLAP After You Install SQL Server 2000 Analysis Services =

Article ID: 282037

Article Last Modified on 5/21/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * 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.

Additional query words: XL2002 XL2003 OLAP Connect MSDA

Keywords: kbbug kberrmsg kbpending KB282037

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.