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