Connection failed to liquibaase db

below command used:
liquibase --url=“jdbc:sqlserver://SERVER.DOMAIN.NET:1435;databaseName=CLM;integratedSecurity=true;encrypt=false” ` --changeLogFile=“changeset_master.xml” validate

ERROR:

Unexpected error running Liquibase: Connection could not be created to jdbc:sqlserver://SERVER.DOMAIN.NET:1435;databaseName=CLM;integratedSecurity=true;encrypt=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. This driver is not configured for integrated authentication. ClientConnectionId:XXXXXX

  • Caused by: Unable to load authentication DLL mssql-jdbc_auth-12.6.0.x
    ERROR: Exception Primary Class: UnsatisfiedLinkError
    ERROR: Exception Primary Reason: Unable to load authentication DLL mssql-jdbc_auth-12.6.0.x64
    ERROR: Exception Primary Source: 4.28.0

Unexpected error running Liquibase: Connection could not be created to jdbc:sqlserver://USAZEMETU09CC.METNET.NET:1435;databaseName=CLM;integratedSecurity=true;encrypt=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. This driver is not configured for integrated authentication.

OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for directory D:\AzDOAgents\agent5_work\1998\s\Database\App
[2025-03-06 02:27:15] FINE [liquibase.configuration] No configuration value for liquibase.searchPath found
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\liquibase-core.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\azure-core-1.45.1.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\azure-core-http-netty-1.13.11.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\azure-identity-1.11.1.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\jackson-databind-2.13.4.2.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\jna-platform-5.6.0.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\json-smart-2.4.10.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\liquibase-azure-deps-4.28.0.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\liquibase-commercial-mongodb-1.1.0.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\msal4j-1.14.1.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\msal4j-persistence-extension-1.2.0.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\mssql-jdbc-12.6.0.jre11.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\oauth2-oidc-sdk-10.7.1.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\lib\slf4j-api-1.7.36 (1).jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for directory D:\Liquibase\lib
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\commons-collections4.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\commons-io.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\commons-lang3.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\commons-text.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\h2.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\hsqldb.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\jaxb-api.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\jaxb-core.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\jaxb-runtime.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\jaybird.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\jcc.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\liquibase-commercial.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\mariadb-java-client.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\mssql-jdbc.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\ojdbc8.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\opencsv.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\picocli.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\postgresql.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\snakeyaml.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\snowflake-jdbc.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for file D:\Liquibase\internal\lib\sqlite-jdbc.jar
[2025-03-06 02:27:15] FINE [liquibase.resource] Creating resourceAccessor for directory D:\Liquibase\internal\lib
[2025-03-06 02:27:15] FINE [liquibase.resource] Overall search path:

  • D:\AzDOAgents\agent5_work\1998\s\Database\App
  • D:\Liquibase\internal\lib\liquibase-core.jar
  • D:\Liquibase\lib\azure-core-1.45.1.jar
  • D:\Liquibase\lib\azure-core-http-netty-1.13.11.jar
  • D:\Liquibase\lib\azure-identity-1.11.1.jar

Hi @Kumar,

Quick question, are you able to connect to that MSSQL DB for an external tool (i.e. DBeaver), but not executing a Liquibase command, correct?

I have comments/questions:

  • It could be you don’t have the correct version of sqljdbc_auth.dll that matches your JDBC driver version and OS architecture. I am not an expert, but I read this could be a reason.
  • Have you try using a different JDBC driver version?
  • Does it make any difference if you add to your URL authenticationScheme=NTLM, plus your credentials?

Please let me know if any of these things might help you, if they don’t I’ll check this with the team.

Thanks,
Daniel.