How to resolve SQL Server 2005 error: The read on the database failed. Reason: Failed to load Msxmlsql.dll
Database Mail, very flexible to setup and easily manageable as compared to its pre-decessor (SQLMail) in previous versions!
Unlike other software application features when it goes wrong its hard to find the root cause, for instance if you see the following error:
Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: The read on the database failed. Reason: Failed to load Msxmlsql.dll.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.QueueItem GetQueueItemFromCommand(System.Data.SqlClient.SqlCommand)
HelpLink: NULL
Source: DatabaseMailEngine
Very easy to find the root cause, eh?
Recently at my work place this has occurred and my colleague has adopted finding methods to resolve this issue, refer to RobertCarrol's blog entry here.