OLAP cube with SQL 2008

[Hetal Jani]

I have Project Server 2007 with SqL 2008.
All the features are working fine as expected. However I am not able to
create OLAP cubes for Data Analysis report.
I get the 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 SERVER
NAME. 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).I saw there are various KB articles available for SQL
2005, have tried those but nothing seems to work.
I have also loaded the DSO components. I need to solve this problem ASAP as
my Senior Management is waiting for some report.
Any help is appreciated.

 

[Christophe Fiessinger [MSFT]]

Have you seen this TechNet article (you need SQL 05 DSO components):
http://technet.microsoft.com/en-us/library/dd285466.aspx