Cannot Connect to OLAP

[Pat]

We are using Project Server 2003 with SQL2000. Our OLAP cube had been
defined and was running fine, however, now it fails with the below
message. We have the same Domain\useraccount defined in both the OLAP
Administrators group on the webserver and database server. I am not
sure if this is the cause but the useraccount had recently been
changed / updated. I have read several related posts but none have
seemed to help. What else am I missing?

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 11/15/2007
Time: 12:13:08 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: HQPRO01
Description:
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 'Unable to connect to the registry on the server
(corsql01), or you are not a member of the OLAP Administrators group
on this server.' Error Number : '-2147221455]]></Description>

 

[adam.lewand]

We are using Project Server 2003 with SQL2000. Our OLAP cube had been
defined and was running fine, however, now it fails with the below
message. We have the same Domain\useraccount defined in both the OLAP
Administrators group on the webserver and database server. I am not
sure if this is the cause but the useraccount had recently been
changed / updated. I have read several related posts but none have
seemed to help. What else am I missing?

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 11/15/2007
Time: 12:13:08 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: HQPRO01
Description:
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 'Unable to connect to the registry on the server
(corsql01), or you are not a member of the OLAP Administrators group
on this server.' Error Number : '-2147221455]]></Description>

This helped me when I had OLAP issues.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;822220