Project Server 2007 “Error: ActiveX component can’t create object” when building Cube
We recently received the following error message when we attempted to build the cube within Project Server 2007:
Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <server>. Error: ActiveX component can’t create object
TechNet has an article (http://technet.microsoft.com/en-us/library/cc197608(office.12).aspx) on this specific error message that basically says you need to make sure you have the SQL Server 2005 Analysis Services components installed on 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 Backwards Compatibility Components (SQLServer2005_BC.msi)
Strange thing was we already had these components installed.
After troubleshooting the issue we determined that the DBAs installed a newer cumulative update on the SQL Server but the components where never updated in the Project Server 2007 environment.
Grabbing the updated components from the matching CU and upgrading those on the Project Server 2007 environment resolved the issue.
Just wanted to share in case anyone else runs into this specific scenario.