ActiveX component can't create object

最新推荐文章于 2021-10-21 14:16:37 发布

转载最新推荐文章于 2021-10-21 14:16:37 发布 · 3.4k 阅读

server 专栏收录该内容

37 篇文章

订阅专栏

本文介绍了解决使用Microsoft Office Project Server 2007 Cube Building Service构建或更新OLAP立方体数据库时出现的“ActiveX组件无法创建对象”错误的方法。此问题可能由缺少必要的SQL Server 2005 Analysis Services组件引起。

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).