al
2005-01-31 17:11:53 UTC
We have a small installation of Project Server, with SQL2k on one box, and
Project / DSO on the other.
I am getting the following error when trying to build my OLAP cube (which we
will use):
Event Source: Microsoft Project Server Tracing Eventlog Provider
User: NT AUTHORITY\LOCAL SERVICE
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Unable to connect to the registry on the server (Dbsrvsql2k), or
you are not a member of the OLAP Administrators group on this server.' Error
Number : '-2147221455]]></Description>
I am an admin on the Project Server, as well as a member of the OLAP Admin
group (just making sure).
a) How (what) do I check for to ensure the proper versions/SP on SQL and DSO
(definitely running SP 3a on SQL2K)?
b) Assuming I have configured COM properly (via PSCOMPlus), how do I verify
this as well?
Thanks in advance...
Project / DSO on the other.
I am getting the following error when trying to build my OLAP cube (which we
will use):
Event Source: Microsoft Project Server Tracing Eventlog Provider
User: NT AUTHORITY\LOCAL SERVICE
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Unable to connect to the registry on the server (Dbsrvsql2k), or
you are not a member of the OLAP Administrators group on this server.' Error
Number : '-2147221455]]></Description>
I am an admin on the Project Server, as well as a member of the OLAP Admin
group (just making sure).
a) How (what) do I check for to ensure the proper versions/SP on SQL and DSO
(definitely running SP 3a on SQL2K)?
b) Assuming I have configured COM properly (via PSCOMPlus), how do I verify
this as well?
Thanks in advance...