Login failures on MSSQL jobs using Windows domain authentication

Document ID : KB000043289
Last Modified Date : 25/06/2018
Show Technical Document Details
Introduction:

Issue: 

When running MSSQL type jobs using the MSSQL plugin against a MSSQL database using Windows domain authentication, job will fail with the message "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

 

Environment:  

Workload Automation Agent for SQL Server

Windows Server

Microsoft SQL Server

Windows Domain Authentication

 

Cause: 

A required parameter (useNTLMv2=true) is missing in the db.properties configuration file.

 

Resolution:

1. Navigate to the location of your db.properties file which is located in the sql folder underneath the config directory of the Agent. The location might look something like "C:\Program Files\CA\WorkloadAutomation_R12\ESPSystemAgent\config\sql;" depending upon where you decided to install the agent.

2. Open the db.properties files. The filename will represent the name of your database server. As an example, it might look something like "WINSQLDE12.properties."

3. Look for the parameter "db.url=" and add ";useNTLMv2=true" to the end of the line. For example: db.url=jdbc:jtds:sqlserver://localhost/msdb;useNTLMv2=true

 

4. Rerun your MSSQL job.

Instructions:
Please Update This Required Field