about 1,5 months ago I have set up a - 1 server - development environment for PS2007. I had installed all components on one Windows 2008 box. Everything worked fine, now I receive an error.
MOSS 2007 SQL 2008 SP1 MOPS 2007 SP2
I have done the additional installation for the cube building part according to this page
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)
Everything worked fine. Cubes were able to be built.. everything was good. In order to have Reports built I added
SSRS 2008 Reporting Services Addin for MOSS (rsSharePoint_x64) Business Intelligence Development Studio (=Visual Studio for MSSQL)
No CUs have been added to this box.
NOW, Cube creation fails with the error:
[CBS] ProjectServerOlapCubeGenerator status: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <IPADDRESS>. Error: ActiveX component can't create object 08efbc13-299a-4abe-9021-c46887ca6915
SSP Name: SharedServices1
PSError: CBSASConnectionFailure (17003)
Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error:
View Complete Post