The cube may not exist, or you may not have permissions to access the cube

[Viren]

Project Server Setup Architecture:
We have the following components installed
1. SQL Server 2000 with SP3a on Server 1
2. SQL Server Analysis Services on Server 1
3. Project Server 2003 with SP2a on Server 2
4. Windows SharePoint Services 2.0 with SP2 on Server 2
5. Domain Setup on Server 3

All the Servers are part of domain 1.

Account Configuration:
* Domain user 'WSSAdmin', to administer WSS, added to local
Administrators group on Server 2
* Domain user 'OlapAdmin', to administer Analysis Services, added to
OLAP Administrator's group on Server 1 and Server 2.

These users have been configured to use COM+ components, using
PSCOMPLUS.EXE

Login to Applications:
User on domain 2 logs in to Server 1 and/or Server 2 (with domain 1
credentials) using Remote Desktop connection and is able to view
Portfolio Analyzer features of Project Server.
FYI - There is a firewall between Server 1 and Server 2 with TCP ports
135, 139, 2725 opened and UDP Ports 137, 138 opened.

User on domain 2 logs in to Project Server using Project Web Access
(with domain 1 credentials) and gets the message:
Unable to access the Microsoft Office Project Portfolio Analyzer OLAP
cube.
The cube may not exist, or you may not have permissions to access the
cube.

FYI - From user's machine on domain 2, TCP ports 2725 opened on Server
1 and UDP Ports 137, 138 opened

Any help would be appreciated.

Thanks in advance.

Regards,

Viren Saini

 

[Mike Glen]

Hi Viren,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP