Masking- Connection error:


Article ID: 140667


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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: 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 




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


Release : 4.8

Component : CA Test Data Manager

CA TDM Portal version


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 and add a new line called 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.