INF: Permission Needed for Administering an OLAP Server

ID: Q231951


The information in this article applies to:


SUMMARY

There are certain permissions required to connect to an OLAP server through the OLAP Manager or through DSO script:

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.

You will see the following error message if you do not have permission on the registry key:
-2147221456 : Cannot open the following registry key on the server computer <computer name>): SOFTWARE\Microsoft\OLAP Server\Server Connection Info
You will see this error message if you do not have permission to access the share:
-2147221466 : Your permissions on the server computer do not allow you to administer this OLAP server.

Error: Path/File access error
Hence, make the user part of the OLAP Administrator's group to successfully administer OLAP Server from the OLAP Manager or from DSO. Note that a client doing OLAP analysis, issuing MDX queries through the OLE DB provider (this includes ActiveX Data Objects (ADO) and ADOMD, Excel, Office Web Components, and third party front end tools), does not read the registry on the server and does not require permission on the MsOLAPRepository$ share.

Additional query words:


Keywords          : kbSQL SSOSdso SSOSmgr 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbinfo 

Last Reviewed: June 4, 1999