<p class="MsoNormal"><span style="font-family: 宋体;">错误信息：装载<span lang="EN-US">
msxmlsql.dll <span style="font-family: 宋体;">失败（<span lang="EN-US">Failed to
load Msxmlsql.dll<span style="font-family: 宋体;">）。
<p class="MsoNormal"><span style="font-family: 宋体;">环境：<span lang="EN-US">ASP.NET2.0 sql Server 2000(SP4)<span style="font-family: 宋体;">。
<p class="MsoNormal"><span style="font-family: 宋体;">出错原因：存储过程中调用了扩展存储过程<span lang="EN-US">sp_xml_preparedocument<span style="font-family: 宋体;">来处理<span lang="EN-US">XML<span style="font-family: 宋体;">数据，但没有找到支持<span lang="EN-US">sp_xml_preparedocument<span style="font-family: 宋体;">运行的<span lang="EN-US">msxmlsql.dll<span style="font-family: 宋体;">文件。
<p class="MsoNormal"><span style="font-family: 宋体;">问题分析：
<p class="MsoNormal"><span style="font-family: 宋体;">首先看到<span lang="EN-US">msxml<span style="font-family: 宋体;">版本已经是最新的<span lang="EN-US">sp2<span style="font-family: 宋体;">版，这个应该没有问题。
<p class="MsoNormal"><span style="font-family: 宋体;">其次去安装<span lang="EN-US">sql
Server<span style="font-family: 宋体;">的位置找<span lang="EN-US">msxmlsql<span style="font-family: 宋体;">名的文件，没有找到。
<p class="MsoNormal"><span style="font-family: 宋体;">再去<span lang="EN-US">C:\Program
Files\Microsoft sql Server\<span style="font-family: 宋体;">下查找，找到了若干个以<span lang="EN-US">msxmlsql<span style="font-family: 宋体;">为名的文件：
后 面发现了下面篇英文文章才真正找到了原因，原因是安装sql Server时没有安装到默认的目录（即%Program Files%\Microsoft sql Server\），而sql Server找msxmlsql.dll时就却到安装目录下找，于是出错了。
解决办法：将%Program Files%\Microsoft sql Server\下的那几个msxmlsql文件拷到（保持目录结构不变）你的安装目录下，重启sql Server服务。一切正常。
附上原文：
sql.DLL) in order to avoid the reboot requirement when installing
sql Server 2005. This change has been released the first time in the April CTP
and will also be included in sql Server 2000 SP4 (yeah!).
sql Server 2005 April CTP that is) in a different location than the
default (so is it still a non-breaking change? :-)).
sql.dll and
.rll are installed to the same location as tools which is a configurable path.
The default install location is:
sql Server\90\Shared
sqlSHAREDDIR is provided on the command line or set during GUI setup
MSXMLsql will be installed to:
sqlSHAREDDIR%\90\Shared
sqlSHAREDDIR%\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 make
sure it does not occur in SP4 either).
原文链接：https://www.f2er.com/mssql/66989.html
