J
Jason
Current Cube Status
The cube scheduled to be built on 10/6/2004 at 8:52 AM failed.
(-2147221455) Unable to connect to the registry on the server
(NAMEOFSERVER), or you are not a member of the OLAP Administrators group on
this server.
I have verified that the user is in the OLAP Administrator group...
I have also done this...
"There are certain permissions required to connect to an OLAP server through
the OLAP Manager or through DSO script:
You need to have permission to access the following registry key on the
server:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\Server Connection Info
You need to have write permissions on the hidden share MsOLAPRepository$,
which contains the OLAP Services repository and locking files. By default
this share is the bin directory under the OLAP Services directory.
You also you need to have Full Control rights on the Bin and Data
directories under the Program Files\Microsoft Analysis Services\Bin
directory. By default, these folders should allow Everyone full control, but
if for security reasons you want to tighten security, make sure that the OLAP
Administrators group keeps the Full Control rights.
When you install OLAP Services, a local group named 'OLAP Administrators' is
created and it is given 'Full Control' to the preceding registry key and to
the MsOLAPRepository$ share. Also the installer is added to the 'OLAP
Administrators' group.
"
Anything else I should check for?
The user that is registered with PSCOMPlus.exe tool is in the OLAP
Administrator group.
The cube scheduled to be built on 10/6/2004 at 8:52 AM failed.
(-2147221455) Unable to connect to the registry on the server
(NAMEOFSERVER), or you are not a member of the OLAP Administrators group on
this server.
I have verified that the user is in the OLAP Administrator group...
I have also done this...
"There are certain permissions required to connect to an OLAP server through
the OLAP Manager or through DSO script:
You need to have permission to access the following registry key on the
server:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\Server Connection Info
You need to have write permissions on the hidden share MsOLAPRepository$,
which contains the OLAP Services repository and locking files. By default
this share is the bin directory under the OLAP Services directory.
You also you need to have Full Control rights on the Bin and Data
directories under the Program Files\Microsoft Analysis Services\Bin
directory. By default, these folders should allow Everyone full control, but
if for security reasons you want to tighten security, make sure that the OLAP
Administrators group keeps the Full Control rights.
When you install OLAP Services, a local group named 'OLAP Administrators' is
created and it is given 'Full Control' to the preceding registry key and to
the MsOLAPRepository$ share. Also the installer is added to the 'OLAP
Administrators' group.
"
Anything else I should check for?
The user that is registered with PSCOMPlus.exe tool is in the OLAP
Administrator group.