Question

Connecting bot with SQL server database error.

I have downloaded JDBC Driver and renamed mssql-jdbc_auth-12.2.0.x64 file to sqljdbc_auth.dll and pasted in 2 places,

1. C:\Program Files\Automation Anywhere\Bot Agent\jre\bin
2. C:\Users\Dell\AppData\Local\Programs\Automation Anywhere\Bot Agent

and my connection string is below: jdbc:sqlserver://SQLEXPRESS;databaseName=Company;integratedSecurity=true

But am getting error, below I have shared a screenshot

+17

@Vanitha Prasad will you be able to connect manually from laptop ?
seems some firewall issue.

Ramesh B Kadiyam

+9

@Vanitha Prasad

According to your error message, the connection string is sqlexpress01. So, try using the following string

jdbc:sqlserver://SQLEXPRESS01;databaseName=Company;integratedSecurity=true

Regards

Sign up