Portal Install / Upgrade fails when using Integrated Authentication

book

Article ID: 110888

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Portal Install / Upgrade fails when using Integrated Authentication.

The following message is logged on an upgrade:
Aug 07, 2018 4:21:09 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNING: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path
Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:4cdd6d28-26ad-4294-b7b0-1d2c61bac489
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1748)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:58)


On fresh installations, the installation cannot proceed passed the Repository configuration dialog. The error "Connection Parameters are invalid" is received.

Cause

The installation cannot find the sqljdbc_auth.dll  in the Java Library Path.

Environment

Release:
Component: TDMWBP

Resolution

To workaround this problem:
  1. Download the attached sqljdbc_auth.dll.
  2. Place the sqljdbc_auth.dll in C:\Windows\System32
  3. Install or Upgrade CA TDM Portal accordingly
  4. Delete the C:\Windows\System32\sqljdbc_auth.dll
This has been fixed in Portal 4.6.8.0 (and later).

Additional Information

Reference documentation: Enable Integrated Security for CA TDM Portal

Attachments

1558536677093sqljdbc_auth.zip get_app