Could not connect to OLAP cube

S

Subbu

i am new to Microsoft Project Server

In Microsoft project Web Access .. on page "Admin\Manage Enterprise
features\Update resource tables and OLAP cube". I provided OLAP cube name
and description, and i choose all other options when i click Update Now ia m
getting error message "Could not connect to the OLAP server specified"

When i look at the event log in computer where MS Project server 2003 is
installed I found some more info

Component: MSP Resource Availability Refresh and OALP Cube
Creation Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description:<Description><!CDATA[DSO.Server.Connect failed with error
message 'Cannot connect to the Analysis server on computer 'typrd01'
Connection to the server is lost Error Number '-2147221387]]>
</Description>

All installs are on different machines
Project server 2003 Build 11.2.2004.1707.15
MS Analysis Server 2000 sp3 (8.00.760)
SQL Servr 2000 (8.00.818)

when i process cibe from OLAP server there were no issues, it went
succesfully.

Please help me out.

Thanks,
Subbu.
 
S

Subbu

Paul Conroy,

Thank you for your response. I have reinstalled Decision Support Objects
(from SQL CD) onto Project Server. It didnt help same error

aRegards,
Subbu.

Paul Conroy said:
Install Decision Support Objects (from SQL CD) onto Project Server.

Subbu said:
i am new to Microsoft Project Server

In Microsoft project Web Access .. on page "Admin\Manage Enterprise
features\Update resource tables and OLAP cube". I provided OLAP cube name
and description, and i choose all other options when i click Update Now
ia m
getting error message "Could not connect to the OLAP server specified"

When i look at the event log in computer where MS Project server 2003 is
installed I found some more info

Component: MSP Resource Availability Refresh and OALP Cube
Creation Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description:<Description><!CDATA[DSO.Server.Connect failed with error
message 'Cannot connect to the Analysis server on computer 'typrd01'
Connection to the server is lost Error Number '-2147221387]]>
</Description>

All installs are on different machines
Project server 2003 Build 11.2.2004.1707.15
MS Analysis Server 2000 sp3 (8.00.760)
SQL Servr 2000 (8.00.818)

when i process cibe from OLAP server there were no issues, it went
succesfully.

Please help me out.

Thanks,
Subbu.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLAP Error / Cube continuously builds 2
'Cannot connect to the Analysis server on computer 2
Cube build fails, security check failure 11
Cannot Connect to OLAP 1
OLAP Connection 5
Cannot build OLAP Cubes MSPS 2003 SP3 SQL Server 2005 SP2 1
OLAP Problem 2
2003 Cube Refresh Error 0

Top