When upgrading Fortify SSC from version 22.2.1 to 23.2.0, Database Test Connection Failed and reported the following message:

Database test connection error: Cannot create PoolableConnectionFactory (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"

To troubleshoot this issue, you can try the following steps:

1. Check Fortify SSC 23.2 system requirement document and make sure Fortify SSC server fulfills all the listed requirements, especially JDK version, Database requirements and etc.

2. Based on the error message, this issue may be caused by SQL connection settings. Please check the database connection settings of SSC initial server configuration, make sure that “encrypt=true;trustServerCertificate=true” is setting in JDBC connection string.

For more information, see trustServerCertificate* JDBC URL properties in the "Setting the connection properties" article at https://learn.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties.