Results 1 to 2 of 2

Thread: SQL Analysis Services

  1. #1
    Join Date
    Nov 2004
    Location
    Malaysia
    Posts
    2

    SQL Analysis Services

    when i try to connect to my analysis server, sometimes it was failed and prompt up the error "Unable to connect Analysis Server. You might be not a member of OLAP Administrator."

    after try a few times, sometimes it will sucessfully connect to it. i can't find out the problem that cause it sometimes failed to connect. anyone can give me a help?

    Thank You!

  2. #2
    Join Date
    Nov 2004
    Location
    Düsseldorf, Germany
    Posts
    1

    I have same problem....

    ...but found a matching error description on microsoft support pages:

    http://support.microsoft.com/default...b;en-us;814414

    This article is something for you, if....
    - you can sometimes connect to olap server and sometimes not
    - you are member of the olap administrators group
    - you have installed Analysis Services SP3 or SP3a
    - the Data folder for Analysis Services is NOT located on a different computer than the computer that has Analysis Services installed.
    - you NOT remotely administer the server from Analysis Manager or from any Decision Support Objects (DSO) application that has not been upgraded to SQL Server 2000 Analysis Services Service Pack 3 or Service Pack 3a

    Perhaps this will help you.

    If not, here are other articles to similar topics:
    http://msdn.microsoft.com/library/en...asp?frame=true
    http://support.microsoft.com/?scid=kb;en-us;Q307365
    http://support.microsoft.com/default...b;en-us;331925
    http://support.microsoft.com/default...b;en-us;812601
    http://support.microsoft.com/default...b;en-us;814139

    Greets,
    Guido Greschuchna
    Düsseldorf, Germany
    Last edited by psycho24; 11-22-2004 at 06:19 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •