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

V

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
 

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