Microsoft KB Archive/929668

From BetaArchive Wiki
Knowledge Base


Error message when you use XML functionalities against an instance of SQL Server 2000 after you upgrade an instance of SQL Server 2000 to SQL Server 2005: "Failed to load msxmlsql.dll"

Article ID: 929668

Article Last Modified on 11/20/2007



APPLIES TO

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit



Bug #: 482386 (SQLBUDT)


SYMPTOMS

Consider the following scenario. A computer is running multiple instances of Microsoft SQL Server 2000. You update one of the instances to Microsoft SQL Server 2005. You use XML functionalities against one of the instances of SQL Server 2000. In this scenario, you receive an error message that resembles the following:

Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line 13
Failed to load msxmlsql.dll.

For example, this problem occurs when you use the sp_xml_preparedocument stored procedure.

CAUSE

This problem occurs because the SQL Server 2005 upgrade removes the following folder:

%ProgramFiles%\Microsoft SQL Server\80\Shared


This folder contains the Msxmlsql.dll file. The Msxmlsql.dll file is required for the XML functionalities in SQL Server 2000.

After the upgrade, access to the shared folder is redirected to the following newly created folder for the instance that is updated:

%ProgramFiles%\Microsoft SQL Server\90\Shared


All instance of SQL Server 2000 on the computer share the removed folder. When you try to use XML functionalities in other instances of SQL Server 2000, SQL Server cannot redirect the Msxmlsql.dll file to the new location.

RESOLUTION

To resolve this problem, use one of the following methods:

  • Copy the %ProgramFiles%\Microsoft SQL Server\90\Shared folder to the %ProgramFiles%\Microsoft SQL Server\80\Shared folder.
  • Copy the %ProgramFiles%\Microsoft SQL Server\80\ folder from an instance of SQL Server 2000 that is installed on another computer to the local computer.


Note Make sure that the version of the Msxmlsql.dll file is the same as the version of the file that was removed by the upgrade. For an installation of SQL Server 2000 Service Pack 4 (SP4), the version of the Msxmlsql.dll file is 1.0.1045.0.


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsql2005setup KB929668