first time set up of DB Agent

[Andy Reimer]

Trying to get a DB agent set up for some testing and proof of concept.  As a test, we are trying to connect the agent to the same database that Workload Automation uses which is hosted on MSSQL.

The db connection string used by the scheduling server looks like this:
jdbc.URL=jdbc:sqlserver://;servername=XXXXXXXXX;port=1433;DatabaseName=XXXXXXXX;selectMethod=cursor;integratedSecurity=true;trustServerCertificate=true

on my test job using the db agent, I configured the db URL in a similar manner:
jdbc:sqlserver://XXXXXXXXX:1433;DatabaseName=XXXXXXXX;integratedSecurity=true;trustServerCertificate=true

but when the job runs it goes into SUBERROR with the following LSTATUS:

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:78043c8e-36b8-44b5-bfaa-2170fc3649de

The database does use integrated security and requires an encrypted connection.

------------------------------
Andy Reimer
------------------------------

[Ravi Kiran Kunduri]

Hi,

Did you get this error even after copying the auth dll file. Can you please follow this procedure and see if this helps

https://knowledge.broadcom.com/external/article/230956/sql-and-windows-authentication-with-wa.html

- Ravi Kiran