This document can also be viewed at https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1568192.html
When launching Subset either through Datamaker or as a separate component and connecting to my database connection profile, I am receiving the following error message: 'Login failed for user X'.
We are using MS SQL Server and Integrated Authentication.
There are two most likely causes for this error message.
1. The sqljdbc_auth.dll file is missing from your C:\Program Files (x86)\Grid-Tools\GTDatamaker folder.
2. You are are adding a username and password in your Subset connection profile.
If you are using Subset with a MS SQL Server (MSSQL) Database that has been configured only for Windows Authentication, but not for SQL Server Authentication, then you will experience this error.
The steps below will enable you to connect to and use data that resides in a MS SQL Server DB (MSSQL DB), that allows only Windows (Integrated) authentication.
1. Go to the 'SQLSERVER_DLLs' folder under the GTDatamaker directory folder.
- By default, this is located at C:\Program Files (x86)\Grid-Tools\GTDatamaker\SQLSERVER_DLLs\x64.
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 GTDatamaker directory folder.
- By default, this is located at C:\Program Files (x86)\Grid-Tools\GTDatamaker.
4. Re-launch the Subset UI.
5. On the Connection screen, enter the MS SQL Server database connection details.
- Remember to not use username and password since you are using Integrated Authentication.
6. Save the profile.
7. Click the 'Connect' button.
- You should now be able to use Subset without receiving the error message.
If you experience any issues, please open a support case either by going to https://support.ca.com or calling CA Support at one of these numbers- https://www.ca.com/us/services-support/ca-support/contact-support.html.
We also would recommend enabling debugging for Subset and sending the resulting log file to support when you open the case. Here are directions on how to do this: https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec1240636.html
If you are experiencing this issue with Subset, you may also face the issue with Fast Data Masker (FDM). Here are directions on how to connect to FDM with MS SQL Server using Windows authentication: https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1139049.html