Cube build failing

[Sumit]

Hi,
I've just installed Project Server 2007 B2TR but unable to build the cube.
After giving all info (Server name, DB name, etc), when i click on save and
build I get following error:
----
Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to connect to the Analysis Services server
ifslagnts4. Error: The connection string to repository needs to be specified
in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file
from Analysis Services 9.0).
-----
Any ideas?
Can I add the info sirectly in the DSO section? if yes then where can I get
the syntax for this?

Regards,
Sumit.

 

[Paul Conroy]

You're using SQL 2005 with Analysis Services 2005 correct ?

B2 TR is not compatible with AS2005, this should be fixed at RTM.

You can get B2TR to work with AS2005 if you know how to create a MSOLAP
repository.

 

[Sumit]

Appreciate your response Paul,
I've been struggling like crazy... I just saw that there is a Project Server
2007 VM available for download.. would check if that has this configured.

Regards,
Sumit.