You cannot use can the MSOLAP provider name to reference the Analysis Services 9.0 OLE DB Provider after you install or repair an Office 2003 program (919427)

The information in this article applies to:

Microsoft Office Professional Edition 2003
Microsoft Office Small Business Edition 2003
Microsoft Office Access 2003
Microsoft Office Excel 2003

SYMPTOMS

Consider the following scenario. You install Microsoft SQL Server 2005 Analysis Services on the computer. Then, you install or repair one of the programs that are listed in the "Applies to" section. In this scenario, you cannot use the MSOLAP provider name to reference the Analysis Services 9.0 OLE DB Provider.

CAUSE

This problem occurs because the Office 2003 Setup program installs the older PivotTable Service. This older PivotTable Service overwrites the version-independent ProgID attribute.

RESOLUTION

How to obtain the hotfix

This issue is fixed in the Office 2003 post-Service Pack 2 Hotfix Package that is dated April 24, 2006. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

913646 Description of the Office 2003 post-Service Pack 2 hotfix package: April 24, 2006

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about this problem, see the Analysis Services 9.0 OLE DB Provider May Be Overwritten By Client Applications topic in section 4.2.3 of the following article in the Microsoft Knowledge Base:

910228 SQL Server 2005 Readme and installation requirements

Modification Type:	Minor	Last Reviewed:	7/26/2006
Keywords:	kbExpertiseInter kbDatabase kbOffice2003preSP3fix kbBug kbfix kbQFE kbprb kbhotfixserver kbpubtypekc KB919427 kbAudITPRO