SQL server Windows Authentication Error

Unexpected error running Liquibase: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:aab7347f-201a-4769-ad75-6ec466fcc9c1

I receive above error while connecting to sql server , connection file i am using looks like below.

SQljdbc auth dll is right here D:\Liquibase\Liquibase-3.8.0-bin\lib\Microsoft JDBC Driver 7.4 for SQL Server\sqljdbc_7.4\enu\auth\x64.

And i am using LB 3.8.0 version.

Any help is much appreciated.

changeLogFile: D:\Liquibase\Liquibase-3.8.0-bin\SQLDatabaseProj\masterchangelog.xml

driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

url: jdbc:sqlserver://localhost:4161;databaseName=FeatureTrackingDM;IntegratedSecurity=true;

classpath:D:\Liquibase\Liquibase-3.8.0-bin\lib\Microsoft JDBC Driver 7.4 for SQL Server\sqljdbc_7.4\enu\mssql-jdbc-7.4.1.jre8.jar

Sure, i already have Sqljdbc_auth.dll available as same path as SQL jdbc driver, but still it didn’t work.

Upon further looking i managed to fix the error , sqljdbc_auth.dll should be copied under windows Java.runtime.path / bin folder.

thanks Steve for your response.

Integrated Security requires access to sqljdbc_auth.dll. This file needs to be accessible in the Windows System path.

Steve Donie Principal Software Engineer Liquibase Community Engagement Datical, Inc. http://www.datical.com/

Yes - because it is a native DLL, it needs to be on the Windows System Path. The driver jars are loaded based on the Java classpath, which is different. 

Glad you were able to get this working. 

Steve Donie
Principal Software Engineer
Liquibase Community Engagement
Datical, Inc. http://www.datical.com/