Project 2003 & Sql 2005 OLAP

[CGambino]

Hello all,

I was wondering if anyone was able to get Project 2003 to connect to a
SQL 2005 OLAP Database. I see that it asks for "Analysis Server" and
"Cube Name"; but it appears that 2005 has a Warehouse layer to it that
isn't accounted for here.

 

[CGambino]

Checking the event log, I found this error:

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message '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).' Error Number : '5]]></Description>


Anyone happen to know how to resolve that?

 

[Sandeep]

Hello,

I also got the same problem, unable to build the cube. I am using MS SQL
2005 with Project Server 2003. I just wanted to know, that if you have been
able to correct the problem ? then please help me also......

Thanks,