Failed to load Msxmlsql.dll

Question

_{Thursday, January 12, 2012 9:04 PM}

I've spent hours  trying to solve this error. I try to run a command in the sharepoint shell and I keep getting this error

All replies (2)

_{Monday, January 16, 2012 3:09 AM ✅Answered}

Hi CuchoI,

Thanks for your post.

The issue may be caused by the version of the Msxmlsql.dll. please try the solution following(please do backup before any actions):

1.       Register the Msxmlsql.dll using Regsvr command. http://ss64.com/nt/regsvr32.html

2.       Copy the Msxmlsql.dll from 90\ Shared folder to “Program Files\Microsoft SQL Server\100\Shared\ folder.

Here is a similar issue:

http://social.msdn.microsoft.com/Forums/en/sqlxml/thread/28f42f15-8ae3-4734-8694-7908fa331a3b

Wayne Fan

TechNet Community Support

_{Monday, January 16, 2012 6:59 AM ✅Answered}

Hi Cuchol,

Thanks for your post.

I suspected the Program Files\Microsoft SQL Server\100\Shared\msxmlsql.dll having been upgraded by the R2-installation to cause the problems. Take a backup of it and replaced it from the msxmlsql.dll from the 90\Shared folder.

It immediately worked, without  registering or anything.

A couple of hits from google for that error ...
 
http://support.microsoft.com/kb/929668
 
http://support.microsoft.com/kb/941105

http://connect.microsoft.com/VisualStudio/feedback/details/103589/sqlcient-error-failed-to-load-msxmlsql-dll

I hope this will help.