ActiveX component can't create object

  • Article

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

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 (https://go.microsoft.com/fwlink/?LinkID=87078\&clcid=0x409).

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for Project Server 2007.