Build Cube Fail

[Liliek]

Friends,

I had problem where I want to build New OLAP in my project server.
this is the message error.
"
Failed to build the OLAP cubes. Error: Analysis Services session failed
with the following error: Failed to connect to the Analysis Services server
a000s-itsql05. Error: ActiveX component can't create object "

What happen this error show up, and ahow to troubleshoot, please advise?

my environment is :
Windows 2003 server Standard Edition, Project Server 2007 and database SQL
server 2005.
I had installed DSO Component in Project Application server and in SQL 2005
Database server.

regards
Liliek

 

[Christophe Fiessinger [MSFT]]

Have you looked at this TechNet documentation:
Troubleshoot the Cube Build Service
http://technet.microsoft.com/en-us/library/cc197709.aspx

 

[Liliek]

Dear Christophe,
From document in your link give me, i had to install
-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)

in both server ( project application server and Database server)
so why this problem still come up??

please hlp

regards
Liliek

 

[Liliek]

dear Christophe Fiessinger,

Thanks, my problem is solve, after I redownload DSO componen,
and reinstall in Project app server and Database server.

so I thinks that DSO component must be same version in both server.
thanks all.

 

[Christophe Fiessinger [MSFT]]

Great, please note that since SQL Server 2005 Sp3 was released last month
the feature has also been updated.