Applies to:
- Liquibase Pro
- Liquibase Open Source (Community)
Conditions:
- Windows
- Microsoft SQL Server
Issue Summary:
Liquibase ships with a version of MS SQL JDBC jar file. To find out which version of the jar file ships with Liquibase, run the liquibase --version command. The output of this command will indicate what version of the driver shipped with Liquibase. For example, here is the output from Liquibase 4.14.0 showing MS SQL driver version 10.2.1:
(base) adeelmalik@Adeels-MBP liquibase-4.14.0 % ./liquibase --version
####################################################
## _ _ _ _ ##
## | | (_) (_) | ##
## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##
## | | | |/ _` | | | | | '_ \ / _` / __|/ _ \ ##
## | |___| | (_| | |_| | | |_) | (_| \__ \ __/ ##
## \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___| ##
## | | ##
## |_| ##
## ##
## Get documentation at docs.liquibase.com ##
## Get certified courses at learn.liquibase.com ##
## Free schema change activity reports at ##
## https://hub.liquibase.com ##
## ##
####################################################
Starting Liquibase at 11:30:40 (version 4.14.0 #3667 built at 2022-07-22 18:36+0000)
Liquibase Home: /Users/adeelmalik/Desktop/LiquibaseHub/liquibase-4.14.0
Java Home /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home (Version 1.8.0_311)
Libraries:
- internal/lib/commons-collections4.jar: Apache Commons Collections 4.4.0 By The Apache Software Foundation
- internal/lib/commons-lang3.jar: Apache Commons Lang 3.12.0 By The Apache Software Foundation
- internal/lib/commons-text.jar: Apache Commons Text 1.9.0 By The Apache Software Foundation
- internal/lib/connector-api.jar: J2EE Connector Architecture API Specification 1.5 By Sun Microsystems, Inc.
- internal/lib/h2.jar: H2 Database Engine 2.1.214 By H2 Group
- internal/lib/hsqldb.jar: HSQLDB 2.5.2 By The HSQL Development Group
- internal/lib/jaxb-api.jar: jaxb-api 2.3.1 By Oracle Corporation
- internal/lib/jaxb-core.jar: JAXB Core 4.0.0 By Eclipse Foundation
- internal/lib/jaxb-runtime.jar: JAXB Runtime 4.0.0 By Eclipse Foundation
- internal/lib/jaybird.jar: Jaybird 4.0.6.java8 (build: variant=jaybird tag=v4.0.6 date=202204271624) By Firebird project
- internal/lib/jcc.jar: IBM JCC JDBC 4 Driver 1.4.0 By IBM
- internal/lib/liquibase-commercial.jar: Commercial Liquibase Functionality 4.14.0 By Liquibase
- internal/lib/mariadb-java-client.jar: mariadb-java-client 3.0.6 By mariadb.com
- internal/lib/mssql-jdbc.jar: Microsoft JDBC Driver for SQL Server 10.2.1 By Microsoft Corporation
- internal/lib/ojdbc8.jar: JDBC 21.6.0.0.1 By Oracle Corporation
- internal/lib/opencsv.jar: opencsv 5.6.0
- internal/lib/picocli.jar: picocli 4.6.3 By Remko Popma
- internal/lib/postgresql.jar: PostgreSQL JDBC Driver 42.4.0 By PostgreSQL Global Development Group
- internal/lib/snakeyaml.jar: SnakeYAML 1.30.0
- internal/lib/snowflake-jdbc.jar: snowflake-jdbc 3.13.20
- internal/lib/sqlite-jdbc.jar: SQLite JDBC 3.36.0.3
Liquibase Version: 4.14.0
Liquibase Community 4.14.0 by Liquibase
Error Message:
The driver is not configured for integrated authentication
Root Cause:
This error is because you may have a version mismatch between the MS SQL JDBC jar file and the DLL file.
Resolution:
The first step is ensuring you followed the instructions for adding the required DLL file in the C:\Windows\System32 directory.
To use a different driver version, download the appropriate driver from this link - Download - JDBC Driver for SQL Server. Extract the JDBC jar file and place it in your /lib directory. Liquibase will automatically use the driver from the /lib directory.
Comments
0 comments
Article is closed for comments.