PRB: Analysis Services with SQL Server Service Pack 3 Cannot Connect to Analysis Services Builds Between 8.00.0671 and 8.00.0727

Article translations Article translations
Article ID: 815486 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SYMPTOMS

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]"

CAUSE

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.

RESOLUTION

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.

MORE INFORMATION

SQL Server 2000 SP3 installs the following versions of the Analysis Services client components:
  • Msolap80.dll
  • Msolap80.rll
  • Msmdgd80.dll
  • Msmdcb80.dll

How to Determine the Analysis Services Build


To determine what version of Analysis Services you are using, follow these steps:
  1. Open Windows Explorer.
  2. Locate, and then right-click Msmdsrv.exe. Click Properties.
  3. 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.
  4. Click OK.

REFERENCES

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

Properties

Article ID: 815486 - Last Review: February 27, 2014 - Revision: 1.3
APPLIES TO
  • Microsoft SQL Server 2000 Analysis Services
Keywords: 
kbnosurvey kbarchive kbupgrade kberrmsg kbprb KB815486

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com