Microsoft KB Archive/292295

= BUG: Unable to Connect to Analysis Services 2000 When OfficeXP is Installed =

Article ID: 292295

Article Last Modified on 10/26/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q292295





SYMPTOMS
If Analysis Services is installed on a system after Microsoft OfficeXP has been installed, OLAP based Pivot Tables in ExcelXP are longer able to communicate with Analysis Services. When you attempt to refresh an existing Pivot Table the following error message occurs in ExcelXP:

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.

When you try to build a new Pivot Table or to connect to the Analysis Services server from the MDX sample application, the following error message occurs:

Unable to open connection.

Provider cannot be found. It may not be properly installed.



CAUSE
When Microsoft OfficeXP is installed it installs version 8.00.195 of the Msolap80.dll file. Analysis Services overwrites the 8.00.195 DLL version with version 8.00.194.



WORKAROUND
To work around this problem, run the OfficeXP or OfficeXP Web Components installation with the detect and repair error option.



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000 Analysis Services version 8.0.

Additional query words: OLAP Analysis Services OWC PTS Pivot Table Service

Keywords: kbproductlink kbbug kbpending KB292295

-

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

© Microsoft Corporation. All rights reserved.