none
Failed to verify Authenticode signature on DLL msxmlsql.dll

    Question

  • Hello, I got this error message. The server is experiencing issue of service broker suddenly stopping, so we are ruling out all errors at this point. Server is setup with HADR.

    Win Server 2008 R2 Ent SP1

    SQL 2012 11.0.3349 Ent

    Log Name:      Application
    Source:        MSSQL$SQL01
    Date:          4/18/2013 7:17:26 AM
    Event ID:      33081
    Task Category: Server
    Level:         Information
    Keywords:      Classic
    User:          N/A
    Computer:      SQL01.xxxxxx.xxx
    Description:
    Failed to verify Authenticode signature on DLL 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL01\MSSQL\Binn\msxmlsql.dll'.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MSSQL$SQL01" />
        <EventID Qualifiers="16384">33081</EventID>
        <Level>4</Level>
        <Task>2</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2013-04-18T11:17:26.000000000Z" />
        <EventRecordID>28935</EventRecordID>
        <Channel>Application</Channel>
        <Computer>SQL01.xxxxxx.xxx</Computer>
        <Security />
      </System>
      <EventData>
        <Data>C:\Program Files\Microsoft SQL Server\MSSQL11.SQL01\MSSQL\Binn\msxmlsql.dll</Data>
        <Binary>398100000A0000000F000000500052004F004400530051004C0031005C0043004F00530051004C000000040000004F006E0065000000</Binary>
      </EventData>
    </Event>

    Thanks.

    Thursday, April 18, 2013 10:38 PM

All replies

  • Hi ASR

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


    Thanks

    Saurabh Sinha

    http://saurabhsinhainblogs.blogspot.in/

    Please click the Mark as answer button and vote as helpful if this reply solves your problem


    Friday, April 19, 2013 2:09 AM
  • Hi ASR,

    Have you found C:\Program Files\Microsoft SQL Server\MSSQL11.SQL01\MSSQL\Binn\msxmlsql.dll? I think msxmlsql.dll is in the C:\Program Files\Microsoft SQL Server\110\Shared. Please check it. You could try to Copying msxmlsql.dll to the Binn folder to see if it would be OK.

    Or you could try to repair the SQL Server through SQL Server Installation Center.

    Thanks.

    If you have any feedback on our support, please click here.


    Maggie Luo
    TechNet Community Support

    Monday, April 22, 2013 7:57 AM
    Moderator
  • I had the Failed to verify Authenticode signature on DLL 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\odsole70.dll' error when a ETL job was attempting to run.  There are .Net/IE STIG hardending restrictions that alter software certificate validation/lookup behavior of the ‘state’ user registry key located @ HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\Software Publishing\.  To get around errors referencing Authenticode signatures / generic trust failures log into the server and delete the ‘state’ registry key and then perform the software install, etc.  If the failure is happening within an application which runs as a specific user, log into the server as the service account user and then delete the key.  The key will automatically be recreated during Group Policy refresh but usually you just need to perform this to get past a certain point with installs/upgrades.
    Wednesday, August 13, 2014 7:36 PM