ActiveX component can't create object

ActiveX component can't create object

Office 2007

2 out of 4 rated this helpful - Rate this topic

Updated: April 23, 2009

 

Topic Last Modified: 2009-11-02

This article describes an error that can occur when you use the Microsoft Office Project Server 2007 Cube Building Service to build or update the OLAP cube database.

Problem description

An error similar to the following appears in the Build Tracking Comments log when you build or update the OLAP cube database:

Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <AnalysisServicesServerName>. Error: ActiveX component can't create object

Possible causes

Three SQL Server 2005 Analysis Services components must be installed on the Project Server application server. If all of them are not installed, then this error occurs.

Solution

Download and install the SQL Server 2005 Analysis Services components to the Project Server application server.

• Microsoft SQL Server Native Client (sqlncli.msi)

• Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi)

• Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi)

These components can be downloaded from the Feature Pack for Microsoft SQL Server 2005 - December 2008 release (http://go.microsoft.com/fwlink/?LinkID=87078&clcid=0x409).