Post reply

Problem accessing Analysis Services

  • February 2, 2007 at 3:28 am

    #369095

    A developer has created a cube and deployed it to Analysis services using BI and SQL server 2005.

     

    I have been asked to allow user access to the cube using a third party tool (Data Analyzer). When I browse to find the cube, I am unable.

     

    I gather this is due to permissions/access rights on the cube/Analysis services.

     

    Can I have some advice on how to grant domain users read only access to the cube.

     

    Thanks in advance.

  • February 2, 2007 at 5:45 am

    #687380

    only a quick guess - but is surface config set correctly?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 2, 2007 at 6:51 am

    #687399

    I checked the surface area config and under Analysis services the following sections are note ticked. Ad-Hoc data mining – anonymous connections – linked objects – user defined function are not ticked.

     

    Under services and connections – Analysis services, remote connection is ticked.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply