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



The information in this article 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 "Symptoms" 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.

Modification Type:MinorLast Reviewed:3/21/2006
Keywords:kbExpertiseAdvanced kbtshoot kbprb KB915111 kbAudDeveloper kbAudITPRO