Action Microsoft.Crm.Setup.Server.InstallConfigDatabaseAction failed. ---> System.Data.SqlClient.SqlException: Failed to load Msxmlsql.dll.

Hi,

Recently faced a very unusual error while installing CRM 2011 on Windows Server 2012 and SQL Server 2012 Business Intelligence edition on the same server.

Error message states something as below:

Action Microsoft.Crm.Setup.Server.InstallConfigDatabaseAction failed.---> System.Data.SqlClient.SqlException: Failed to load Msxmlsql.dll. Could not find prepared statement with handle 0. sp_xml_removedocument: The value supplied for parameter number 1 is invalid.

After searching for a hell lot of time on web about this error faced by anyone during CRM 2011 installation. I failed to find any thing relevant.

The error message above even did not have anything suspicious linking it back to CRM 2011 but rather seems more inclined towards SQL Server. I got an idea about checking the word sp_xml_removedocument in the folder of CRM 2011 installation files and that resulted in an sql file named "Reserved.sql" on the path \config\5.0\Scripts. 

(Taking a little pause here, let me just tell you that the all scripts on this path are executed on the configuration database during CRM installation which sets the default values in the configuration tables)

So I manually tried to execute "Reserved.sql" in SQL Server Management Studio and found the same error about loading of Msxmlsql.dll assembly.

I searched Msxmlsql.dll on the SQL Server 2012 installation disk and found it but was unable to find the same in the installation folder on the server.

Voila !!! Caught the problem and so then the solution was just round the corner.

Solution:

Copy the missing files from installation disk location to the installation target folder on the server as below:

msxmlsql.dll
From the disk: \x64\Setup\sql_engine_core_shared_msi\PFiles\SqlServr\110\Shared\msxmlsql.ddl
To : \Program Files\Microsoft SQL Server\110\Shared

msxmlsql.rll
From the disk: \1033_ENU_LP\x64\Setup\sql_engine_core_shared_loc_msi\PFiles\SqlServr\110\Shared\Res\1033\msxmlsql.rll
To : \Program Files\Microsoft SQL Server\110\Shared\Resources\1033

Looking to solution it seems like SQL Server 2012 installation fails to copy the above files to the target installation folder on the server.

After the above steps done, CRM 2011 Installation worked like a charm.  J

Hope you find above solution helpful. Kindly provide your valuable comments or suggestions on this post.

Thank You !!! J