Article ID: 873440 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Bug #: 14399 (Plato7x)
This article describes the following about this hotfix release:
If you create a custom cube role to define the dynamic dimension security to restrict the dimension members that are visible to users, and you then specify the top dimension level that can be accessed by the users in the custom cube role, you may receive one of the following error messages when you try to browse a cube by using the custom cube role:
Error message 1
Analysis Server Error: Connection to the server is lost;
Error message 2
Unable to process one or more commands.
This problem occurs when all the following conditions are true:
After you receive the error message, the custom cube role that you used to define the dynamic dimension security is corrupted. As a result, all the users who belong to the cube role will not be able to access the dimension until the dimension is rebuilt. Also, Analysis Manager may report the following error message:
"Possible data corruption".
For a list of previous hotfixes, see the "Microsoft SQL Server 2000 post-Service Pack 3 or Microsoft SQL Server 2000 post-Service Pack 3a hotfixes" section in the following Microsoft Knowledge Base article:
(http://support.microsoft.com/kb/290211/ )How to obtain the most recent SQL Server 2000 service pack
(http://support.microsoft.com/kb/290211/ )How to obtain the latest SQL Server 2000 service pack
(http://support.microsoft.com/kb/290211/ )How to obtain the most recent SQL Server 2000 Service Pack
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
SQL Server 2000 Analysis Services Service Pack 3
This hotfix build is designed for a server that is running Microsoft SQL Server 2000 Analysis Services Service Pack 3.
Note Because of file dependencies, the most recent hotfix that contains these files may also contain additional files.
Date Time Version Size File name ------------------------------------------------------------------------- 06-Apr-2004 07:56 18,800 Msmd.h 26-Jul-2004 05:01 8.0.964.0 221,760 Msmdcb80.dll 26-Jul-2004 05:01 22.214.171.1244 4,063,808 Msmddo80.dll 26-Jul-2004 05:01 8.0.964.0 1,036,864 Msmdgd80.dll 26-Jul-2004 05:01 8.0.964.0 172,608 Msmdpump.dll 26-Jul-2004 03:59 8.0.964.0 446,524 Msmdsgn.rll 26-Jul-2004 05:01 126.96.36.1994 9,642,564 Msmdsgn80.dll 26-Jul-2004 05:01 8.0.964.0 1,839,684 Msmdsrv.exe 26-Jul-2004 05:01 8.0.964.0 2,085,456 Msolap80.dll 26-Jul-2004 03:39 8.0.964.0 213,068 Msolap80.rll
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.
For more information about dynamic dimension security, click the following article number to view the article in the Microsoft Knowledge Base:
828343For more information about Analysis Services operations, visit the following Microsoft TechNet Web site and read the "Security Administration" section:
(http://support.microsoft.com/kb/828343/ )Support WebCast: Dynamic dimension security in Microsoft SQL Server 2000 Analysis Services
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx#XSLTsection128121120120For more information about the naming schema for Microsoft SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
822499For more information about the terminology that Microsoft uses when orrecting software after it is released, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/822499/ )New naming schema for Microsoft SQL Server software update packages
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
Contact us for more help
Connect with Answer Desk for expert help.