Test Data Manager

  • 1.  Tech Tip: Connection error in Fast Data Masker

    Posted Sep 27, 2016 04:47 PM

    Knowledge document: http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1369915.aspx 

     

    Issue: 

    After launching Fast Data Masker (FDM) and connecting to a SQL Server database profile, I get the error message ‘Connection Error: This driver is not configured for integrated authentication.authentication.’

    Error recreation steps:

    1. Launch FDM by double clicking on the icon on your desktop, or by going to your FDM directory located at C:\ProgramFiles\Grid-Tools\FastDataMasker and double clicking on the GTMAPPER.exe.
    2. Copy the default connection 'connectSQLSERVER.txt' by selecting it in the 'Connection Profiles' list on the left of the window and then clicking on the 'Copy Connection' button at the bottom of the window.
    3. Enter in you own database connection information including:

    - New connection name 

    Note: This is the name that will show in the 'Connection Profiles' list once it is saved. You will not see any underscores you type inside this connection window. It will look like there is a space there instead. For example, ‘connect_test’ will appear as ‘connect test’. If you get an error about the ‘Connection Name’, make sure the name starts with the word ‘connect’ before it.

    - Choose 'SQL SERVER' from DBMS drop down box.

    Note: The options of what you will be typing in next will change based on what DBMS is chosen from the drop down.

    - Server Name\Instance 

    - User Name

    - Password

    - Port

    Note: If this is a trusted connection, you should not have to enter a username, password, or port.

    - Database Name

    - Default Schema

    1. Save the connection by clicking on the 'Save' button at the bottom of the window.
    2. Connect to this profile by clicking on the 'Connect' button at the bottom of the window.

    Now you will see the error- ‘Connection Error: This driver is not configured for integrated authentication.Authentication.’

    Environment:  

    Fast Data Masker (FDM)

    SQL Server 2008 R2, 2012, or 2014.

    Cause: 

    If you get this error, it means that you are missing a SQL Server authentication DLL file from your Fast Data Masker directory folder.

    Resolution:

    1. After getting this error, close your FDM application.
    2. Go to your FDM directory. The default installation location for this will be located at C:\ProgramFiles\Grid-Tools\FastDataMasker
    3. Open up the SQLSERVER_DLLs folder.
    4. Copy the file labeled sqljdbc_auth.dll.  
    5. Paste this sqljdbc_auth.dll into your FastDataMasker folder located at C:\ProgramFiles\Grid-Tools\
    6. Re-launch FDM by double clicking on the icon on your desktop, or going to C:\ProgramFiles\Grid-Tools\FastDataMasker and double clicking on the GTMAPPER.exe.
    7. Enter in the SQL Server database credentials you used previously.
    8. Click the ‘Save’ button.
    9. Click the ‘Connect’ button.

    You should now be able to connect to Fast Data Masker and the first page you see is within the ‘Masking’ tab.

    Additional Information:

    If you experience any more issues connecting, please open a support case.



  • 2.  Re: Tech Tip: Connection error in Fast Data Masker

    Posted Mar 05, 2018 08:17 AM

    I've just followed the guidance in this Tech Tip and it works great for FDM if you choose the 'Save & Run Mask' option.

    If you choose 'Save Mask' and then run the .bat file from a command prompt, the error "This driver is not configured for windows authentication still occurs.

    This can be resolved by placing 'sqljdbc_auth.dll' somewhere that can be found via the %PATH% environment variable.  For example, local to where the .bat file runs, or C:\Windows\System32, etc...

     

    In fact, if 'C:\Program Files\Grid-Tools\FastDataMasker\SQLSERVER_DLLs\x64' is added to %PATH%, then it solves both cases in one.