TDM 4.11 Connection Profile throws integrated authentication error

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

After upgrading to TDM Portal 4.11.62.0, we ran through steps that we had for configuring TDM Portal for Windows Integrated Security, and placed a copy of the %ProgramFiles%\Grid-Tools\FastDataMasker\SQLSERVER_DLLs\x64\mssql-jdbc_auth-12.2.0.x64.dll inside the %CATDMWEB_HOME%\service\lib directory. 

Now we are seeing the following error when test the connect profile in TDM Portal:

This driver is not configured for integrated authentication. ClientConnectionId:<connectionID_string>

Environment

TDM Portal 4.11.62.0

Cause

Looking at the TDMConnectionProfileManager.log, we see:

c.c.t.c.d.s.TDMDriverManagerDataSource:  Error during open connection: This driver is not configured for integrated authentication. ClientConnectionId:<connectionID_String>
java.lang.UnsatisfiedLinkError: Unable to load authentication DLL mssql-jdbc_auth-12.4.2.x64
    at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:63)

The error states that we could not load authentication DDL mssql-jdbc_auth-12.4.2.x64. TDM Portal 4.11 comes with the mssql-jdbc_auth-12.4.2.x64.ddl file by default. Please check %CAWTDMWEB_HOME%\service\lib and verify that you have a copy of the mssql-jdbc_auth-12.4.2.x64.dll file in this location, and that it hasn't been replaced by a different DDL.

Resolution

Replacing the copy of the missing mssql-jdbc_auth-12.4.2.x64.ddl file and restarting the CA Test Data Manager Portal service resolved the issue.

Additional Information

If you do not have a copy of the required ddl, please open a support case and ask the TDM Support team to provide you a copy. 

The most recent TDM patches are available for download at the Test Data Manager (TDM) Support Patches page.