Results 1 to 5 of 5

Thread: Analysis Services server not available

  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Analysis Services server not available

    Hi
    I installed Analysis Services yesterday and was building some test cubes from our receipts data, today, when I tried opening my cubes, it appears that my Analysis Server (on local machine - laptop) is not available – giving the error message of :

    "Unable to connect to the registry on the server FJKILKEN-MOBL, or you are not a member of the OLAP Administrators group on this server"


    I have shut-down/restarted, and then checked that all appropriate services (SQL server, OLAP server etc…) are running – which they are – any idea on what the issue could be?

    Thanks a lot

    Fergal

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Ensure your windows account is member of olap admin group on the server.

  3. #3
    Join Date
    Aug 2005
    Posts
    1

    You need Analysis sp3

    Hi,
    you will need to install sql2kasp3.exe (which is the service pack analysis services, download from MS) and be a member of the OLAP Admin group.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    The latest sp is sp4.

  5. #5
    Join Date
    Sep 2002
    Posts
    169
    You will also need to install the same analysis services SP on your workstation. Sp3a introduced security enhancements that check the client SP and refuse to permit you to use Analysis Manager - you get misleading error messages such as the message you are getting !

Posting Permissions

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