ActiveX component can't create object
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).