FDM - Connecting to MSSQL DB using Windows authentication
search cancel

FDM - Connecting to MSSQL DB using Windows authentication

book

Article ID: 46712

calendar_today

Updated On:

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".