Re: Unable to connect to Analysis Server

#1 (**permalink**) 02-27-2008, 05:08 PM

Do you apply SP3?

--
Jose Mariano Alvarez
Comunidad de base de datos
Grupo de Usuarios Microsoft
www.mug.org.ar

"Kristofer Gafvert" <kgafvert@NEWSilopia.com> wrote in message
news:uh2FTQRYDHA.2548@TK2MSFTNGP09.phx.gbl...
> Just installed the Analysis Service (for the first time, trying to
> understand it). However, when i try to connect to my server (in Analysis
> Manager, Console Root/Analysis Servers/<myServerName>) i get this error
> message:
>
> "Unable to connect to the registry on the server (myServerNameHere), or
you
> are not a member of the OLAP Administrators group on this server."
>
> I have verified that i am in the group OLAP Administrators. I'm logged on
to
> the machine with an account that is a member of the group Administrators,
so
> i should have full access to the registry. What makes this even more
strange
> is that i sometimes (not very often!) can access the server, just a few
> seconds after a failed attempt, but it is not working as expected. For
> example, if i try to view the Data tab for a cube, i get: "Unspecified
> Error". So i think there are some kind of security problems here too. But
> what is the problem? Everything is running locally, both SQL Server and
> Analysis Server.
>
> I've tried to reinstall Analysis Server.
> I've tried to logon as Administator, still the same error message.
> I've tried to change the account used by MSSQLServerOLAPService to an
> account with administrator privilegies (saw that you had to do something
> like that if you did not use the default settings when installing, but i
did
> use default for everything).
>
> Anyone have any tips for this? I would like to keep on reading my book,
but
> for now i'm stuck on the first chapter :-(
>
> --
> Regards,
> Kristofer Gafvert (dial-up for the moment - posts might be delayed)
> http://www.ilopia.com - My personal Web Site, with information about
things
> i find interesting, for example Windows Server 2003.
> Reply to newsgroup only. Remove NEWS if you must reply by email, but
please
> do not.
>
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode