Question

Connecting bot with SQL server database error.

  • 10 March 2023
  • 2 replies
  • 32 views

Badge

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

 


2 replies

Userlevel 5
Badge +10

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

Userlevel 5
Badge +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

Reply