Unable to execute liquibase update on the new mssql dsetup

Liquibase Development
1

Getting following error… What could be the issue? I did setup the liquibase.properties file with right DB URL, Username and Password.

Starting Liquibase at 14:10:52 (version 4.17.1 #5120 built at 2022-10-21 13:42+0000)

Liquibase Version: 4.17.1

Liquibase Community 4.17.1 by Liquibase

Unexpected error running Liquibase: Connection could not be created to jdbc:sqlserver://localhost:1433;databaseName=master; with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. 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”. ClientConnectionId:d1f7fb68-0f88-45ed-ba4e-9a7f9a95fadc

2

It is resolved. I changed the URL to following in liquibase.properties

url=jdbc:sqlserver://localhost:1433;databaseName=master;integratedSecurity=false;encrypt=true;trustServerCertificate=true