Microsoft KB Archive/915111

= An error or an access violation occurs when you try to restore an archive file for a SQL Server 2000 Analysis Services database =

Article ID: 915111

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-





SYMPTOMS
Consider the following scenario. You try to restore an archive file for a Microsoft SQL Server 2000 Analysis Services database. The server on which you try to restore the archive file and the server on which the archive file was originally created have different regional settings or different language settings. In this scenario, you experience one or more of the following problems:
 * Incorrect data is returned.
 * An error or an access violation occurs when additional members are added to a dimension.
 * An error or an access violation occurs when new data is added to a cube or to a partition.
 * An error or an access violation occurs when you try to query the data.



CAUSE
This problem occurs because the scenario in the &quot;Symptoms&quot; section is not supported. Both servers must have the same regional settings or the same language settings.



MORE INFORMATION
An additional error may occur in this scenario. When you restore an archive that contains only metadata, the object names in the archive may conflict with the different regional settings, with the different language settings, or with the different comparison flags. This may cause an error to occur.

Keywords: kbexpertiseadvanced kbtshoot kbprb KB915111

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.