Error when trying to build OLAP Cubes

[TheWall]

"Failed to build the OLAP cubes." Error: Analysis Services session failed
with the following error: Failed to connect to the Analysis Services server .
"Error: ActiveX component can't create object"

SQL Server 2005 and Project Server 2007 is on separe servers.
I Installed the DSO software on the Project Server.

 

[TheWall]

Solution:
http://technet.microsoft.com/en-us/library/cc197608.aspx

 

[Prasanth]

Our client have project server 2007 and SQL server 2005 with analysis
services on different servers.We installed all cient components(native
client,backward compatability ans managemnet objects collection) on both
servers and configured DSO on analysis services by using both Analysis
Services 2000 repository file(msmdrep.mdb) and creating a database for
Analysis services 2005 repository file.
But still we are getting the same problem "Activex component can't be
created".

Please do let me know how to fix this issue,

Thanks and Regards,
Prasanth Kumar.Ch.

 

[TheWall]

Hi,

Got my solution from the following url:
http://technet.microsoft.com/en-us/library/cc197608.aspx