Windows Authentication failure for Microsoft SQL Server database plugin.

Products

• CA Workload Automation DE - Business Agents (dSeries)

Issue/Introduction

Installed the database and microsoft sql plug-in on the agent. Installed and copied the jTDS JDBC driver file (jtds-1.3.1.jar) into agent directory (jars/ext).

Added in the (db.domain) into the db.properties file to enable windows authentication as well.

Windows Authentication failure for Microsoft SQL Server database plugin.

XX/XX/2021 00:00:28.639-0700 1 DatabasePlugin.database Internal Thread.CybWOBRunSqlHandler.processWob[:78] - java.sql.SQLException: Login failed for user 'domain\user1'.

The same job runs fine with 'sa' authentication

Environment

WADE 12.3 server

WA Agent for Database 12.0.00.00-2049 

WA Agent for MS SQL Server 12.0.00.00-2031

Resolution

Edit the agentparm.txt

db.default.url=jdbc:jtds:sqlserver://XXXXXX:1433;DatabaseName=XXX_DB;domain=XXXX

Add the useNTLMv2=TRUE so that it should look like this

db.default.url=jdbc:jtds:sqlserver://XXXXXX:1433;DatabaseName=XXX_DB;domain=XXXX;useNTLMv2=TRUE

Then restart the agent and run the test job again.

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/workload-automation-agent-for-databases/12-0/installing/install-ca-wa-agent-for-databases.html

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/workload-automation-agent-for-microsoft-sql-server/12-0/installing/install-ca-wa-agent-for-microsoft-sql-server/configure-the-target-server-database-properties-file.html