Analysis services in Excel

Discussion in 'microsoft.public.sqlserver.datamining' started by yeezez, May 6, 2010.

  1. yeezez

    yeezez Guest

    Hello,

    I might have misunderstood something completly, but at present I do the
    following for SQL Server which is on another windows domain (Hosted machines)

    1. Grant public select to certain tables
    2. Connect to them in excel using the databasepassword.

    I want to do something similar with the cubes I make. My plan was as follows:

    1. Grant anonymous access to analysis services (NT AUTHORITY\ANONYMOUS LOGON)

    2. Create roles for the cubes I want to show (I then use a existing user on
    the hosted domain)
    3. Then connect to these via excel.

    The problem is that when I try to connect via Excel (I have opened port 2383)
    is that I get no reply from the server.

    Any ideas? Which password should I use in excel? None? The role I created?

    Regards,

    Y.
     
    yeezez, May 6, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.