SQL Server 装载 msxmlsql.dll 失败的解决办法

qaqa12345667

错误信息：装载msxmlsql.dll 失败（Failed toload Msxmlsql.dll）。
环境：ASP.NET2.0  SQL Server 2000(SP4)。
出错原因：存储过程中调用了扩展存储过程sp_xml_preparedocument来处理XML数据，但没有找到支持sp_xml_preparedocument运行的msxmlsql.dll文件。
问题分析：
首先看到msxml版本已经是最新的sp2版，这个应该没有问题。
其次去安装SQLServer的位置找msxmlsql名的文件，没有找到。
再去C:\ProgramFiles\Microsoft SQL Server\下查找，找到了若干个以msxmlsql为名的文件：


后面发现了下面篇英文文章才真正找到了原因，原因是安装SQL Server时没有安装到默认的目录（即%ProgramFiles%\Microsoft SQL Server\），而SQL Server找msxmlsql.dll时就却到安装目录下找，于是出错了。

解决办法：将%Program Files%\Microsoft SQL Server\下的那几个msxmlsql文件拷到（保持目录结构不变）你的安装目录下，重启SQL Server服务。一切正常。

附上原文：
As part of ourimprovements on OpenXML, we have changed the MSXML component from 2.6 to 3.0(running in 2.6 backwards-compatibility mode) and moved to a private DLL(called MSXMLSQL.DLL) in order to avoid the reboot requirement when installingSQL Server 2005. This change has been released the first time in the April CTPand will also be included in SQL Server 2000 SP4 (yeah!).
A couple ofpositives are that the parser will scale linear to the size of the document(there were cases when MSXML 2.6 was superlinear, ugh!), and the parent axisaccess in column pattern expressions will be finally performing (compared tothe 2.6 based engine, it should be lightning fast :-)).
However, the AprilCTP seems to have an installation bug, if one decides to install the databaseengine (SQL Server 2005 April CTP that is) in a different location than thedefault (so is it still a non-breaking change? :-)).
MSXMLSQL.dll and.rll are installed to the same location as tools which is a configurable path.The default install location is:
%ProgramFiles%\Microsoft SQL Server\90\Shared
However, ifINSTALLSQLSHAREDDIR is provided on the command line or set during GUI setupMSXMLSQL will be installed to:
%INSTALLSQLSHAREDDIR%\90\Shared
Since the code onlylooks in the first location, it will not find it. So, if you encounter theabove error message, please just copy the missing files from%INSTALLSQLSHAREDDIR%\90\Shared to %Program Files%\Microsoft SQL Server\90\Shared.We are working to get this fixed for the next CTP release (and of course makesure it does not occur in SP4 either).
If you installeverying using default location, this is not an issue.
（http://www.sqljunkies.com/WebLog/mrys/archive/2005/04/22/12478.aspx）