SQL server Windows Authentication Error

Community Answers
1

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

2

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.

3

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/
4

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/

6

Hi Everyone,

Please assist I have the same issue.
I’ve downloaded the the Microsoft JDBC Driver for SQL Server from the Microsoft site.

I got the mssql-jdbc_auth-10.2.0.x64.dll from the installation and copied it over to my java path C:\Program Files\RedHat\java-1.8.0-openjdk-1.8.0.265-3\bin

mssql_auth
mssql_auth645×674 74.5 KB

After all of that I seem to continue having the same error.
I would really appreciate some assistance here.

Kind Regards,

Hloni

ERROR LOG:
NB! in the log I’ve replaced the real host name with <HOSTNAME> for company security reasons.
[2022-02-19 22:35:54] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 ClientConnectionId: 2d2defdf-452d-4f1e-9f02-f4cfb3a21681 sleeping milisec: 1000
[2022-02-19 22:35:55] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 This attempt server name: port: 1433 InstanceName: null useParallel: false
[2022-02-19 22:35:55] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 This attempt endtime: 1645302958266
[2022-02-19 22:35:55] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 This attempt No: 13
[2022-02-19 22:35:55] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection connectHelper] ConnectionID:1 Connecting with server: port: 1433 Timeout slice: 2857 Timeout Full: 15
[2022-02-19 22:35:55] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin] ConnectionID:1 ClientConnectionId: 605936a4-9bca-4748-b0cf-0bf780076650 Server returned major version:15
[2022-02-19 22:35:55] FINE [com.microsoft.sqlserver.jdbc.SQLServerException logException] *** SQLException:ConnectionID:1 ClientConnectionId: 605936a4-9bca-4748-b0cf-0bf780076650 com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:605936a4-9bca-4748-b0cf-0bf780076650 This driver is not configured for integrated authentication. ClientConnectionId:605936a4-9bca-4748-b0cf-0bf780076650
[2022-02-19 22:35:55] FINE [com.microsoft.sqlserver.jdbc.SQLServerException logException] com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3145)com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:72)com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3937)com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:85)com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3926)com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3200)com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2707)com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2356)com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2207)com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1270)com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:861)liquibase.database.jvm.JdbcConnection.open(JdbcConnection.java:44)com.datical.liquibase.ext.database.jvm.ProJdbcConnection.open(Unknown Source)liquibase.database.ConnectionServiceFactory.create(ConnectionServiceFactory.java:32)liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:214)liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:176)liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:141)liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:92)liquibase.integration.commandline.Main.doMigration(Main.java:1517)liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:398)liquibase.Scope.lambda$child$0(Scope.java:180)liquibase.Scope.child(Scope.java:189)liquibase.Scope.child(Scope.java:179)liquibase.Scope.child(Scope.java:158)liquibase.integration.commandline.Main$1.run(Main.java:397)liquibase.integration.commandline.Main$1.run(Main.java:221)liquibase.Scope.child(Scope.java:189)liquibase.Scope.child(Scope.java:165)liquibase.integration.commandline.Main.run(Main.java:221)liquibase.command.AbstractCliWrapperCommandStep.run(AbstractCliWrapperCommandStep.java:32)liquibase.command.CommandScope.execute(CommandScope.java:157)liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)picocli.CommandLine.executeUserObject(CommandLine.java:1953)picocli.CommandLine.access$1300(CommandLine.java:145)picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2352)picocli.CommandLine$RunLast.handle(CommandLine.java:2346)picocli.CommandLine$RunLast.handle(CommandLine.java:2311)picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)picocli.CommandLine.execute(CommandLine.java:2078)liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:325)liquibase.Scope.child(Scope.java:189)liquibase.Scope.child(Scope.java:165)liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:291)liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:80)
[2022-02-19 22:35:55] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 ClientConnectionId: 605936a4-9bca-4748-b0cf-0bf780076650 sleeping milisec: 1000
[2022-02-19 22:35:56] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 This attempt server name: port: 1433 InstanceName: null useParallel: false
[2022-02-19 22:35:56] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 This attempt endtime: 1645302958266
[2022-02-19 22:35:56] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 This attempt No: 14
[2022-02-19 22:35:56] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection connectHelper] ConnectionID:1 Connecting with server: port: 1433 Timeout slice: 1784 Timeout Full: 15
[2022-02-19 22:35:56] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin] ConnectionID:1 ClientConnectionId: a6ddf42d-9c66-4442-ac4c-6188f217c217 Server returned major version:15
[2022-02-19 22:35:56] FINE [com.microsoft.sqlserver.jdbc.SQLServerException logException] *** SQLException:ConnectionID:1 ClientConnectionId: a6ddf42d-9c66-4442-ac4c-6188f217c217 com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:a6ddf42d-9c66-4442-ac4c-6188f217c217 This driver is not configured for integrated authentication. ClientConnectionId:a6ddf42d-9c66-4442-ac4c-6188f217c217
[2022-02-19 22:35:56] FINE [com.microsoft.sqlserver.jdbc.SQLServerException logException] com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3145)com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:72)com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3937)com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:85)com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3926)com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3200)com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2707)com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2356)com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2207)com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1270)com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:861)liquibase.database.jvm.JdbcConnection.open(JdbcConnection.java:44)com.datical.liquibase.ext.database.jvm.ProJdbcConnection.open(Unknown Source)liquibase.database.ConnectionServiceFactory.create(ConnectionServiceFactory.java:32)liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:214)liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:176)liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:141)liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:92)liquibase.integration.commandline.Main.doMigration(Main.java:1517)liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:398)liquibase.Scope.lambda$child$0(Scope.java:180)liquibase.Scope.child(Scope.java:189)liquibase.Scope.child(Scope.java:179)liquibase.Scope.child(Scope.java:158)liquibase.integration.commandline.Main$1.run(Main.java:397)liquibase.integration.commandline.Main$1.run(Main.java:221)liquibase.Scope.child(Scope.java:189)liquibase.Scope.child(Scope.java:165)liquibase.integration.commandline.Main.run(Main.java:221)liquibase.command.AbstractCliWrapperCommandStep.run(AbstractCliWrapperCommandStep.java:32)liquibase.command.CommandScope.execute(CommandScope.java:157)liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)picocli.CommandLine.executeUserObject(CommandLine.java:1953)picocli.CommandLine.access$1300(CommandLine.java:145)picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2352)picocli.CommandLine$RunLast.handle(CommandLine.java:2346)picocli.CommandLine$RunLast.handle(CommandLine.java:2311)picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)picocli.CommandLine.execute(CommandLine.java:2078)liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:325)liquibase.Scope.child(Scope.java:189)liquibase.Scope.child(Scope.java:165)liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:291)liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:80)
[2022-02-19 22:35:56] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 ClientConnectionId: a6ddf42d-9c66-4442-ac4c-6188f217c217 sleeping milisec: 1000
[2022-02-19 22:35:57] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 This attempt server name: port: 1433 InstanceName: null useParallel: false
[2022-02-19 22:35:57] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 This attempt endtime: 1645302958266
[2022-02-19 22:35:57] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection login] ConnectionID:1 This attempt No: 15
[2022-02-19 22:35:57] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection connectHelper] ConnectionID:1 Connecting with server: port: 1433 Timeout slice: 663 Timeout Full: 15
[2022-02-19 22:35:57] FINE [com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin] ConnectionID:1 ClientConnectionId: 443f15f7-41e8-447a-a311-c50fc69e5bc5 Server returned major version:15
[2022-02-19 22:35:57] FINE [com.microsoft.sqlserver.jdbc.SQLServerException logException] *** SQLException:ConnectionID:1 ClientConnectionId: 443f15f7-41e8-447a-a311-c50fc69e5bc5 com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:443f15f7-41e8-447a-a311-c50fc69e5bc5 This driver is not configured for integrated authentication. ClientConnectionId:443f15f7-41e8-447a-a311-c50fc69e5bc5
[2022-02-19 22:35:57] FINE [com.microsoft.sqlserver.jdbc.SQLServerException logException] com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3145)com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:72)com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3937)com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:85)com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3926)com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3200)com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2707)com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2356)com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2207)com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1270)com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:861)liquibase.database.jvm.JdbcConnection.open(JdbcConnection.java:44)com.datical.liquibase.ext.database.jvm.ProJdbcConnection.open(Unknown Source)liquibase.database.ConnectionServiceFactory.create(ConnectionServiceFactory.java:32)liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:214)liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:176)liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:141)liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:92)liquibase.integration.commandline.Main.doMigration(Main.java:1517)liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:398)liquibase.Scope.lambda$child$0(Scope.java:180)liquibase.Scope.child(Scope.java:189)liquibase.Scope.child(Scope.java:179)liquibase.Scope.child(Scope.java:158)liquibase.integration.commandline.Main$1.run(Main.java:397)liquibase.integration.commandline.Main$1.run(Main.java:221)liquibase.Scope.child(Scope.java:189)liquibase.Scope.child(Scope.java:165)liquibase.integration.commandline.Main.run(Main.java:221)liquibase.command.AbstractCliWrapperCommandStep.run(AbstractCliWrapperCommandStep.java:32)liquibase.command.CommandScope.execute(CommandScope.java:157)liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)picocli.CommandLine.executeUserObject(CommandLine.java:1953)picocli.CommandLine.access$1300(CommandLine.java:145)picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2352)picocli.CommandLine$RunLast.handle(CommandLine.java:2346)picocli.CommandLine$RunLast.handle(CommandLine.java:2311)picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)picocli.CommandLine.execute(CommandLine.java:2078)liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:325)liquibase.Scope.child(Scope.java:189)liquibase.Scope.child(Scope.java:165)liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:291)liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:80)
[2022-02-19 22:35:57] SEVERE [liquibase.integration] Connection could not be created to jdbc:sqlserver://;portNumber=1433;databaseName=DevOps_Testing;integratedSecurity=true; with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. This driver is not configured for integrated authentication. ClientConnectionId:443f15f7-41e8-447a-a311-c50fc69e5bc5
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:sqlserver://;portNumber=1433;databaseName=DevOps_Testing;integratedSecurity=true; with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. This driver is not configured for integrated authentication. ClientConnectionId:443f15f7-41e8-447a-a311-c50fc69e5bc5
at liquibase.command.CommandScope.execute(CommandScope.java:163)
at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
at picocli.CommandLine.executeUserObject(CommandLine.java:1953)
at picocli.CommandLine.access$1300(CommandLine.java:145)
at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2352)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2346)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2311)
at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)
at picocli.CommandLine.execute(CommandLine.java:2078)
at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:325)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:165)
at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:291)
at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:80)
Caused by: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:sqlserver://;portNumber=1433;databaseName=DevOps_Testing;integratedSecurity=true; with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. This driver is not configured for integrated authentication. ClientConnectionId:443f15f7-41e8-447a-a311-c50fc69e5bc5
at liquibase.integration.commandline.Main$1.run(Main.java:443)
at liquibase.integration.commandline.Main$1.run(Main.java:221)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:165)
at liquibase.integration.commandline.Main.run(Main.java:221)
at liquibase.command.AbstractCliWrapperCommandStep.run(AbstractCliWrapperCommandStep.java:32)
at liquibase.command.CommandScope.execute(CommandScope.java:157)
… 14 more

7

Hi @Jazziro , Thanks for the question. As stated before, the dll needs to be in the %PATH% environment of your windows system and not the java path.