Cannot Connect to OLAP

P

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>
 
A

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
 

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

Top