RE: Analysis Services Permissions Error

From: David (David_at_discussions.microsoft.com)
Date: 08/24/04


Date: Tue, 24 Aug 2004 11:49:02 -0700

So I know it is some authentication error. I installed office on my server,
so now I can access the portfolio analyzer through Project Web Access.
What I can not do is access it from another computer.
For Analysis Services, I made a role called Project User, and had the
IUSR_<SERVER NAME> as a member, as well as the server Administrators and OLAP
Administrator roles. That should be the only problem.

Please provide any further help.

David

"Robert Enroughty" wrote:

> I assume you migrated the AS DB to SQL Server already.
>
> Did you add the PM that needs to access the cube/view to
> the local group OLAP Administrators on the server running
> Analysis Services? This was my problem. I added the PM
> then re-preocessed the cubes and she can access them now.
>
> >-----Original Message-----
> >HELP MVPS!!!
> >
> >I am still getting the following error when trying to
> access the Views
> >section in manage views. I have successfully create an
> OLAP Cube as well.
> >
> >I have done the following to try and fix this problem.
> >
> >Unable to access the Microsoft Office Project Portfolio
> Analyzer OLAP cube.
> >
> >Possible Cause : The cube has not yet been built, or it
> is currently being
> >generated, or you do not have permission to access the
> cube.
> >
> >
> >1. Set permissions in Analysis Services, under manage
> roles.
> >2. Set permissions in PWA.
> >3. Set permissions to the bin folder in Analysis
> Services.
> >4. Activated all ActiveX controls in IE, under Security-
> >Trusted Sites.
> >
> >SQL Server 2000 and Analysis Services have been installed
> on the same box,
> >and the SP3 for both have been update.
> >
> >I know it is a permissions error. Do I need to have some
> sort of Office
> >software installed on the Server as well to enable the
> Office Web Components?
> >
> >Please help
> >
> >David
> >
> >
> >
> >
> >.
> >
>



Relevant Pages

  • Analysis Services Permissions Error
    ... Unable to access the Microsoft Office Project Portfolio Analyzer OLAP cube. ... Set permissions in Analysis Services, ... SQL Server 2000 and Analysis Services have been installed on the same box, ...
    (microsoft.public.project.pro_and_server)
  • OLAP cube build with Project Server 2007
    ... I have a problem with building the OLAP cube from PS2007. ... Analysis Services, and I try to build the cube from a remote computer. ... Services server sqlsrv. ... administrators account. ...
    (microsoft.public.sqlserver.olap)
  • Re: OLAP cube build initialises but never completes
    ... It sound as though the person that initated the OLAP cube isn't set up as ... user against the cube in Analysis Services. ... Finally make sure there is enough contiguous disk space on your server. ...
    (microsoft.public.project.pro_and_server)
  • Re: Using forms authentication to control security access to msolap.asp. Is it possible using ASP.NE
    ... (including the username/pwd coming from your ASP.NET server. ... This uses http connectivity with a known username and pwd. ... SQL BI Product Unit (Analysis Services) ... >> authentication problem is resolved. ...
    (microsoft.public.sqlserver.olap)
  • Re: Relational to DW.?
    ... Analysis Services for some time. ... data on the same server. ... > interesting question......I assume your 'relational database' is for a ... > just finished it but have not put the pointer to it on my web site ...
    (microsoft.public.sqlserver.datawarehouse)