Login failures on MSSQL jobs using Windows domain authentication
search cancel

Login failures on MSSQL jobs using Windows domain authentication

book

Article ID: 43289

calendar_today

Updated On:

Products

Workload Automation Agent

Issue/Introduction

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