Skip to main content
Question

Latest Database connection package (5.6.6) fails. Older versions work (5.4.0)

  • August 13, 2026
  • 1 reply
  • 47 views

It seems like the newest database package is failing in my tasks.

Here is my step detail:

The error I get is: 

com.automationanywhere.botcommand.database.adapter.exceptions.BotCommandDatabaseException:
Could not Connect to Database.
"encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption:
Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

We use self signed certs on our network which I assume is causing this.

 

I was able to get the connect working by changing from user defined to “default” and generating my own JDBC connection string.

jdbc:sqlserver://{{ipaddress}}:1433;databaseName=RPA_AP_Invoice;encrypt=true;trustServerCertificate=true;username={{user}};password={{pass}};

My change was to set “trustServerCertificate” to “true”.

 

My main question is why isn’t this (and encryption) configurable on the “User defined” connection method?

1 reply

Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+6
  • Automation Anywhere Team
  • August 13, 2026

@sleemand Good question. The self-signed certificate is indeed the source of the issue.

I’m wondering if installing the certificate in the Windows certificate stores could alleviate this issue. 

What I would recommend is sending an email to support@automationanywhere.com and asking for an enhancement for these security options.