OLAP cube build with Project Server 2007

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,
I have a problem with building the OLAP cube from PS2007. I am using a
two servers environment:one for PS2007, one for SQL 2005 Server and
Analysis Services, and I try to build the cube from a remote computer.
I went through the steps described in
http://technet2.microsoft.com/Office/en-us/library/ec990b7c-ec98-4d6d-b1a1-081a67fd66cc1033.mspx?mfr=true
which should be enough for everything to go well. But when I try to
build the cube, using Project Web Access I receive this error message:

Failed to build the OLAP cubes. Error: Analysis Services session
failed with the following error: Failed to connect to the Analysis
Services server sqlsrv. Error: Your permissions on the server computer
do not allow you to administer this Analysis server.

I logg on these servers with the same account, and it is an
administrators account.
any suggestions?
thanks,
Lavi

.

Relevant Pages

  • RE: Analysis Services Permissions Error
    ... 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 ... > Analyzer OLAP cube. ... Set permissions in Analysis Services, ...
    (microsoft.public.project.pro_and_server)
  • Re: Building a Portfolio Analysis Services
    ... Before the system can created the OLAP cube, you must have one or more ... Server database, you must do the following to set up the building of the ... > And now I'm going to setup a Analysis Service Server ...
    (microsoft.public.project.pro_and_server)
  • OLAP cube not accessible to the Groups - Project Manager or Executive
    ... Administrator on the server was not able to view the ... able to view the Portfolio Analyzer (no longer received ... Add the Windows User Account to the cube in Analysis ... Resource Tables and OLAP Cube page in Microsoft Project ...
    (microsoft.public.project.pro_and_server)
  • RE: How to connect to AS from a different server running Reporting Ser
    ... > the ASPNET account from a different server. ... > All my reports are based on data from OLAP cubes, ... > not having access to the OLAP cube. ...
    (microsoft.public.sqlserver.olap)
  • RE: unable to access portfolio analyzer via internet
    ... You need to have the enterprise version of SQL Server 2000 to support access ... to the OLAP cube via the internet. ... > allow access to the portfolio analyzer through the internet. ... > get through to web access, but cannot view portfolio analyzer at all. ...
    (microsoft.public.project.pro_and_server)