Analysis Services Security

From: Thomas (thomasniles@hotmail.com)
Date: 09/10/02 

From: "Thomas" <thomasniles@hotmail.com>
Date: Tue, 10 Sep 2002 11:08:00 -0700

I have created several cubes on Analysis Services and am
trying to have a user access the cube through Excel pivot
table services. When trying to set-up the connection to
AS the error message below is returned. What do I need to
do in the way of permissions to allow the end user(s)
access to the cubes on the server? Thanks in advance.

Thomas

Unable to open connection. Cannot connect to
server 'ServerName' OLAP Server error: The operation
requested failed due to security problems (the user could
not be authenticated).

Relevant Pages

  • Tell Me About Your DW Development Life Cycle
    ... What are some good ways to get development cubes into ... I currently use a developer's edition of SQL Server 2000 ... Connect to the production server via VPN and run the ... Analysis Services Server and rebuild cubes. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Cube access problem
    ... In a Analysis Services ... server there is a series of cubes with their permissions of access ... because the server does not allow the access him ... permissions without changing nothing, everything works OK and the user ...
    (microsoft.public.sqlserver.olap)
  • Analysis Services Security
    ... I have created several cubes on Analysis Services and am ... trying to have a user access the cube through Excel pivot ... server 'ServerName' OLAP Server error: ...
    (microsoft.public.win2000.security)
  • Re: Cant connect to / see cube
    ... SQL BI Product Unit (Analysis Services) ... > I have a development domain, with one server running SQL Server 2000 sp ... > I restored the database from a cab-file, ... > prosess 2 out of 4 individual cubes. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Issue with Migrating OLAP Cube
    ... > uat server, but the underlying SQL database differs. ... > I tried your #2 using my AS dbname1 on my dev machine. ... I copy those same cubes from ...
    (microsoft.public.sqlserver.olap)