This article has been archived. It is offered "as is" and will no longer be updated.
After you install SQL Server 2000 Service Pack 3 (SP3), or Analysis Services Service Pack 3, you might not be able to connect to a server that is running an Analysis Services build between 8.00.0671 and 8.00.0727. You might also receive the following error message:
Cannot open connection to Analysis server '<ServerName>'. Error in data [Possible data corruption]"
The Msolap80.dll and Msmdgd80.dll files in SQL Server 2000 SP3 are incompatible with the Analysis Services Msmdsrv.exe file for builds between 8.00.0671 and 8.00.0727.
To resolve this problem, install Analysis Services Service Pack 3 on the computer that has an Analysis Services build between 8.00.0671 and 8.00.0727 installed.
SQL Server 2000 SP3 installs the following versions of the Analysis Services client components:
How to Determine the Analysis Services Build
To determine what version of Analysis Services you are using, follow these steps:
Open Windows Explorer.
Locate, and then right-click Msmdsrv.exe. Click Properties.
In the Msmdsrv Properties dialog box, click the Version tab. Note the value displayed for File version. This is the current build of Analysis Services.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
331925 FIX: Pre-Analysis Services Service Pack 3 Client Cannot Administer Analysis Services Service Pack 3