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:
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