Masking- Connection error: com.microsoft.sqlserver.jdbc.SQLServerException

book

Article ID: 140667

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

CA TDM Portal/local installation of GT Datamaker/Local installation of MS SQL Server Express (NOT DOCKER).  

CA TDM Portal service and MS SQL Server services are set to Windows Authentication. Integrated Security is turned on.  

We Can connect to the SQL Express server, CA TDM PORTAL able to build/connect, am able to establish GTREP DB and Connection profile.

Able to launch portal, set up connection profile, every time i mask I get the above error.

But when I try to do masking from the Portal , I am getting the below error: 

 

         c.c.t.f.s.CallFastDataMasker:  #0: 2019-11-14 11:32:03.068 close: closing down. Final job state: FAILED
2019-11-14 16:32:03.110 UTC [INFO ] [SimpleAsyncTaskExecutor-2] --- [U:][M:][P:]                      c.c.t.f.s.CallFastDataMasker:  #0: 2019-11-14 11:32:03.068 run: FDM progress thread:  Sending final notification: state: FAILED
2019-11-14 16:32:03.110 UTC [INFO ] [SimpleAsyncTaskExecutor-2] --- [U:][M:][P:]                      c.c.t.f.s.CallFastDataMasker:  #0: 2019-11-14 11:32:03.069 #FDM_METRICS{"jobState":"FAILED","totalRows":"0","rowsMasked":"0","errors":"Connection error: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:5b975cd1-ce6e-4b14-83e0-230abe239bf9, Error connecting with connection parameters"}#END_FDM_METRICS
2019-11-14 16:32:03.110 UTC [INFO ] [SimpleAsyncTaskExecutor-2] --- [U:][M:][P:]                      c.c.t.f.s.CallFastDataMasker:  #0: 2019-11-14 11:32:03.069 exit value = 1 

 

 

Cause

To use integrated security FDM needs to have access to sqljdbc_auth.dll. Looks like platform mismatch or some issue in locating the library

Environment

Release : 4.8

Component : CA Test Data Manager

CA TDM Portal version 4.8.100.3.

Resolution

As a workaround : 

Make the following changes to the portal configuration and then retest the masking job.

1                 Stop the TDM Portal Service

2                 Edit the file - c:\Program Files\CA\CA Test Data Manager Portal\service\conf\wrapper.conf

a.      Find the entry wrapper.java.library.path.1 and add a new line called wrapper.java.library.path.2 which points to this location C:\Program Files\Grid-Tools\FastDataMasker\SQLSERVER_DLLs\x64 like this.


3                 Start the TDM Portal Service

4                 Retest the masking job that uses the integrated security settings.