SQL Server Performance

Analysis Services

Discussion in 'Analysis Services/Data Warehousing' started by Shruthi04, Aug 9, 2006.

  1. Shruthi04 New Member

    Hi All..
    Am totally new to SQL.. Now am trying to use Analysis Services.. I have just installed Analysis service Complonents.. When I try to open it I get the following error. Can anyone help me out in solving this..
    Thanks in advance

    Error :

    DSOInfo: Cannot create temp directory C:program FilesMicrosoft Analysis ServicesBin.. Help80metadatmetatemp100.
    Shruthi04, Aug 9, 2006
    #2

  2. ranjitjain New Member

    Have you created and added user in olap administrator group on analysis services box.
    ranjitjain, Aug 9, 2006
    #2

  3. Shruthi04 New Member

    Thanks for your reply.. No, I haven't added user.. When i try to open itself i get this message.. May I know how to do that...
    Shruthi04, Aug 9, 2006
    #2

  4. ranjitjain New Member

    Analysis server uses windows credentials while connecting.
    Either you login as administrator or add your username in administrator group or olap Administrator group.
    You can add your username under computer management and then local users and groups
    on analysis server box.

    Moderators,
    can you please move this thread to relevant forum.
    ranjitjain, Aug 10, 2006
    #2

  5. ranjitjain New Member

    you can even try by running analysis services to run as particular account which is your windows account and not as ntauthority/system account.
    ranjitjain, Aug 10, 2006
    #2

  6. satya Moderator

    Check this KBAhttp://support.microsoft.com/kb/295737/EN-US/ in this case and please post thread inrelevant forums only.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
    satya, Aug 10, 2006
    #2

  7. Shruthi04 New Member

    Thanks for all your replies..
    As i was new to this forum i dint knew where to post.. Hereafter will be cautious
    Thanks for relevent link..
    Shruthi04, Aug 10, 2006
    #2

Share This Page