OLAP Cube Access problem

[a a]

Hi

We have a problem with OLAP cube access.
After creating an OLAP Cube for Portfolio Analyzer usage, I migrated OLAP
Cube database to MSSQL Server 2000, then gave permissions to (domain) users
as stated in Project Server 2003 installation manual.

But when a user tries to look at Portfolio related page, there comes an
authentication box. After submitting the login information, we get an error
like this:

Unable to open connection. the operation failed due to security problems.
the user could not be authenticated.

Only administrator user of Project Server is able to access the OLAP cube.
How can we give access to other users without authentication or How to make
it in a secure way? (Do we have to use SSL?)

Thanks in advance.

 

[Gary L. Chefetz [MVP]]

Answered in your previous post. Please post your questions only once. If you
don't receive an answer in a couple days, it's a good idea try again, as
long as you provide more information.