Article ID: 293616 - View products that this article applies to.
This article was previously published under Q293616
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 11603 (Plato7x)
For each Analysis server, Microsoft(r) SQL Server(tm) 2000 Analysis Services creates a repository, called the Analysis Services repository, to store meta data for the objects of the Analysis server (cubes, dimensions, and so on). By default, this repository is a Microsoft Access (.mdb) database on the server computer where Analysis Services is installed.
You can use the Migrate Repository Wizard to migrate the Analysis Services repository to a Microsoft SQL Server 7.0 database or a SQL Server 2000 database on the same server, another server, or to the SQL Server 2000 Meta Data Services repository format. Microsoft recommends that you choose the SQL Server database format if you are planning to migrate the repository.
However, if you have already migrated the repository to the Meta Data Services repository format and you are now planning to migrate it back to a SQL Server 7.0 OLAP Services format, you must follow the steps outlined in the "More Information" section.
To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.
How to Migrate Repository to SQL Server 7.0 OLAP Services Format
A known issue exists regarding the migration of an Analysis Services repository from Meta Data format to SQL Server format when the target database is in SQL Server 7.0. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/293627/EN-US/ )BUG: Failure to Migrate Repository from Meta Data Format to SQL Server 7.0 Format
Article ID: 293616 - Last Review: October 23, 2013 - Revision: 1.2