Skip to main content
Navigator | Tier 3
August 13, 2026
Question

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

  • August 13, 2026
  • 3 replies
  • 12 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?

    3 replies

    Aaron.Gleason
    Automation Anywhere Team
    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. 

    sleemandAuthor
    Navigator | Tier 3
    August 13, 2026

    I did send an email but received a reply saying the ticket was closed. Not sure if that is expected. Case 02331266.

     

    No luck so far with installing the cert, but I’m not completely sure I’m getting the right one.

    Aaron.Gleason
    Automation Anywhere Team
    Automation Anywhere Team
    August 13, 2026

    @sleemand Not sure why you got that reply. Maybe an auto-reply by a support bot. Just reply to the email again asking for the enhancement.

    Installing certs in Windows is a pain. For Windows 11, open the Microsoft Management Console (MMC) by typing mmc in the Run dialog, then add the Certificates snap-in for the Computer account, and import the desired certificate into the Trusted Root Certification Authorities store. Follow the prompts in the Certificate Import Wizard to complete the installation.

    Easy, right?  🤣