gilta03

Tech Tip: 'Login failed for user' Error when Connecting to Subset with Integrated Authentication

Discussion created by gilta03 Champion on Mar 21, 2017

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

 

login failed for user.PNG

 

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:

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 

Outcomes