OLAP cube access from a different domain.

[Anonymous]

Hello,

I am getting error ' Unable to access OLAP cube' while creating a new
Portfolio Analyzer view. My setup is as follows..

There are three servers - A Domain controller, a project server 2003 and a
database server. Analysis services is on database server. DSO is installed on
the project server. Service pack 3a is successfully applied on database
server, analysis server and DSO. Domain controller contains the
(domain\Username) account setup for access.

I am accessing project server through a web access client which is NOT on in
the same domain as that of the project server and database server. While
trying to create a new portfolio analyzer view i am getting the above
mentioned error.

I have checked for permissions on the cube and they are ok. Also note that
when i try to access project server through project web access on the same
machine(i.e project server itself) i am NOT getting this error and it
successfully connects to the cube.

Is this problem due to access from another domain? What is that i need to do
for giving the cube access seemless of domains?

Any help will be appreciated!!

Thank you..

 

[Gary L. Chefetz \(MVP\)]

You need a trust relationship between the domains. Otherwise, you must use
the Enterprise edition of SQL and expose the Analysis functionality over
http. You'll find info on this at http://support.microsoft.com

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-