Analysis Services server not available

Printable View

12-21-2004, 07:40 AM
fjkilken

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
12-27-2004, 11:25 AM
rmiao

Ensure your windows account is member of olap admin group on the server.
08-01-2005, 04:14 AM
stresshead

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.
08-01-2005, 11:28 AM
rmiao

The latest sp is sp4.
08-01-2005, 09:51 PM
Stephen

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 !