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

  • Question

  • Hi All,

    I am installing CRM 2011 on Windows Server 2012 and SQL Server 2012 installed on the same server. Its a single server environment.

    I have followed all the initial steps to start the manual installation from command prompt as stated in the below article since found the issues with auto updates installation for SHS from CRM Installer.

    http://support.microsoft.com/kb/2434455 

    Was able to reach the last step where all the validations are done before actual setup starts. All validation checks were successful and the setup started but in the middle of the installation, got below error with installation was terminated.

    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.

    For more information, I am using the account who is inside the Domain Administrator group and also local administrator on the Server machine as well as having "sysadmin" role on the SQL Server 2012 which I am using for CRM 2011.

    Can anyone please help me out with this error?



    Prathmesh If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful" http://patelprathmesh.blogspot.com/

    Saturday, July 20, 2013 5:34 PM

Answers

  • Surprisingly the above issue got resolved. :)

    Looking to the resolution it seems like SQL Server 2012 installation fails to copy Msxmlsql.dll and msxmlsql.rll from the setup DVD to the actual installation folder.

    Solution:

    Copy the missing files from DVD setup location to the installation target folder as below:

    msxmlsql.dll
    From the DVD: \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 DVD: \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

    After the above steps performed, CRM 2011 Installation finished like a charm.

    :)



    Prathmesh If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful" http://patelprathmesh.blogspot.com/

    • Marked as answer by Prathmesh P Saturday, July 20, 2013 7:00 PM
    • Unmarked as answer by Prathmesh P Sunday, July 21, 2013 6:43 PM
    • Marked as answer by nrodriEditor Monday, July 22, 2013 10:22 AM
    Saturday, July 20, 2013 7:00 PM