Hi,

After installing SP3, I can open the Analysis Manager once, but after
closing it, it won't let me back in.

After opening Analysis Manager and attempting to connect to the only server,
after several minutes, I get an error saying it cannot connect because the
user is not a member of the OLAP Administrators group.

SQL Server and Analysis Server are both running locally on a new Dell
computer.

I have repeatedly assigned the proper group to my user account with no
success.

In order to get access again, I have to re-install SP3a.

Please Help,
Dave C.

try this
1.. Give the OLAP Administrators group full control of the remote Data
folder of Analysis Service.
2.. Give the MSSQLServerOLAPService start-up account full control of the
remote Data folder.
3.. Give the OLAP Administrators group full control of the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server

"Dave C" <DCatherman (AT) cmisolutions (DOT) com> a écrit dans le message de news:
uGGG2riqDHA.648 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Thanks,

I have accomplished steps 1 and 3 without results, but need some explanation
on step 2.

Dave
"Olivier" <ziton (AT) hotmail (DOT) com> wrote

i mean :
look at the account who start MSSQLServerOLAPService (and MSSQLSERVER
service)
It must be in OlapAdministrator's group and OlapAdministrator's group must
have the full control of the remote Data folder
or make sure that this account has the full control of the remote Data
folder and registry.




"Dave C" <DCatherman (AT) cmisolutions (DOT) com> a écrit dans le message de news:
uIx$AOtqDHA.2064 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

I have finally found a solution to this problem. All you have to do is open
the Advanced User and Groups MMC and open the "OLAP Administrators" group.
Remove and re-add your username. This correct the problems in the registry.
Dave C.

----- Original Message -----
Sent: Thursday, November 13, 2003 4:56 PM
Subject: Re: Can't get back in to analysis services