This document can also be viewed at https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1568192.html
Issue:
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.
Environment:
CA Test Data Manager (TDM)- GT Subset
Cause:
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.
Resolution:
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.
Additional Information: