Authenticode signature warnings for JDBC XA integration library

Taras Tielkes 1 Reputation point
2021-02-12T20:52:26.4+00:00

We're using the XA integration library provided as part of the MSSQL JDBC driver.

In the MSSQL log, we observe the following message:

Failed to verify the Authenticode signature of 'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\SQLJDBC_XA.dll'. Signature verification of SQL Server DLLs will be skipped. Genuine copies of SQL Server are signed. Failure to verify the Authenticode signature might indicate that this is not an authentic release of SQL Server. Install a genuine copy of SQL Server or contact customer support.

The version of MSSQL is:

Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

Looking at the digital signature of the SQLJDBC_XA.dll in question, it appears to have a valid trust path. The package has been downloaded from the Microsoft site here: https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#82

The specific version we're using is the x64 8.2.2 release. The validity period of the Authenticode signature ends 5/2/2020, and I assume that this is what is triggering this warning. However, the other components in the Binn directory of the MSSQL 2016 installation have Authenticode signatures with long-expired validity periods as well.

What is the reason for the warning, and how should it be resolved?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,045 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-02-15T09:12:38.74+00:00

    Hi TarasTielkes-7336,

    Are there any updates on this issue?
    Could you please try to copy the new sqljdbc_xa.dll from the JDBC driver installation directory to “C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\”? If you are using XA transactions with a 32-bit SQL Server, use the sqljdbc_xa.dll file in the x86 folder(\sqljdbc_x.x\enu\xa\x86), even if the SQL Server is installed on a x64 processor. If you are using XA transactions with a 64-bit SQL Server on the x64 processor, use the sqljdbc_xa.dll file in the x64 folder(\sqljdbc_x.x\enu\xa\x64).

    And here is an article which might help.

    Best Regards,
    Amelia

    0 comments No comments