FDM - Connecting to MSSQL DB using Windows authentication

Document ID : KB000046712
Last Modified Date : 29/08/2018
Show Technical Document Details
Issue:

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.