FDM - Connecting to MSSQL DB using Windows authentication

Products

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

Issue/Introduction

The MS SQL Server (MSSQL) Database has been configured only for Windows Authentication, but not for SQL Server Authentication. How can FastDataMasker (FDM) connect to a MS SQL Server (MSSQL) using Windows authentication?

Environment

Masking Target DB: MS SQL Server with Windows authentication (all supported versions)

Resolution

1. Browse to the "SQLSERVER_DLLs" folder under the "FastDataMasker" installation folder (by default, C:\Program Files\Grid-Tools\FastDataMasker).
2. Copy the file named "sqljdbc_auth.dll" from under the "x64" subfolder. This is the 64-bit version of the DLL and is the one you will need assuming your system runs on a 64-bit processor.
3. Paste the sqljdbc_auth.dll file to the "FastDataMasker" folder (by default, C:\Program Files\Grid-Tools\FastDataMasker).
4. Re-launch the FDM UI and on the connection screen and enter the MSSQL Server DB connection details.
5. Make sure the username and password fields are left blank.
6. Save the profile and click the "Connect" button".

Additional Information

After copying over the sqljdbc_auth.dll file, if you get error messages like "This driver is not configured for windows authentication”, it is most likely that the incorrect version of sqljdbc_auth.dll has been copied. Repeat the process with a different version of the DLL. Here is a knowledge document that you can review to help resolve this error: Connection error in Fast Data Masker

Similar problems will also occur with Subset. See Errors when Connecting to Subset with Integrated Authentication for details to resolve them in Subset.