You may receive an error message when you try to run a drillthrough query on a server that is running Analysis Services SP4 (908538)

The information in this article applies to:

Microsoft SQL Server 2000 Analysis Services

SYMPTOMS

When you try to run a drillthrough query on a server that is running Microsoft SQL Server 2000 Analysis Services Service Pack 4 (SP4), you may receive the following error message:

The Operation requested failed due to security problem - resource access error

CAUSE

This problem may occur when all the following conditions are true:

The user is not a member of the OLAP Administrators group on the server computer.
The user is not a member of the Administrators group on the client computer.
The user has a role on the server that is running Analysis Services SP4, and the role's enforcement location is set to Server.
The version of the Msolap80.dll file on the client computer has a minor build number that is less than 2039. For example, the build number will be less than 8.0.2039.
The server is running Analysis Services SP4 or a later version of Analysis Services.

RESOLUTION

To resolve this problem, use one of the following methods:

Set the role's enforcement location role to Client.
Download and install the Analysis Services SP4 version of the Ptslite.exe file on the client computer. We recommend that the version of the client components be the same version as the server components.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information, visit the following Microsoft Developer Network (MSDN) Web sites:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/pt_intro_61b9.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/pt_intro_4fhv.asp

Modification Type:	Major	Last Reviewed:	1/28/2006
Keywords:	kberrmsg kbBug kbtshoot kbprb KB908538 kbAudDeveloper kbAudITPRO