Error: [08S01] This driver is not configured for integrated authentication.
I am using IntelliJ IDEA 2017.2 with DataGrip integrated into it. I am trying to connect to a local version of MS SQL Server 2016 and their example database, WideWorldImporters.
I can successfully connect using SQL Server Management Studio 17.2 but when I try the same connection from within IntelliJ, I get the "driver is not configured for integrated authentication" error. From reading elsewhere I gather this is likely because the sqljdbc_auth.dll file is not being found or is mismatched with something.
I have copied the sqljdbc_auth.dll to everywhere I can see suggested:
C:\windows\system32
C:\Program Files (x86)\Java\jdk1.8.0_60\bin
C:\Program Files (x86)\Java\jdk1.8.0_60\jre\bin
C:\Program Files (x86)\Java\jre1.8.0_60\bin (I have jre1.8.0_66 on my machine but it does not have a bin folder just a lib one)
C:\Program Files (x86)\JetBrains\IntelliJ IDEA 2017.1\jre64\bin
I have included the first 3 of the above locations in my system variables Path statement (but none of them are in my user variables Path statement)
I am using the version of sqljdbc_auth.dll found in the following directory:
C:\Program Files (x86)\Microsoft JDBC Driver 6.2 for SQL Server\sqljdbc_6.2\enu\auth\x64
I am running Windows 10 on a machine that says its system type is a 64-bit operating system, x64-based processor.
Am I using the correct (best) driver? Am I using the correct (best) sqljdbc_auth.dll?
Do I have the sqljdbc_auth.dll in the correct (best) folder?
Do I need to add or change anything in my Path statement?
Is there some other cause for the connection failure?
Thanks for your help.
Please sign in to leave a comment.
Hi,
Could you provide any IDE logs and a screenshot of your ms sql data source settings and your driver settings?
E.g., for driver settings:
Thank you.
Thanks Vasily
Here is my screenshot
And here is an IDE log extract. Note the message at the very last line. Does this means I should use the 32 bit driver?
2017-08-25 18:49:57,533 [3175718] INFO - urce.DatabaseConnectionManager - No user name provided (may be in url)
2017-08-25 18:49:57,533 [3175718] INFO - urce.DatabaseConnectionManager - Connecting to: jdbc:sqlserver://localhost; instancename=SQLEXPRESS;integratedSecurity=true;
2017-08-25 18:49:57,765 [3175950] WARN - ution.rmi.RemoteProcessSupport - Aug 25, 2017 6:49:57 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
2017-08-25 18:49:57,765 [3175950] WARN - ution.rmi.RemoteProcessSupport - WARNING: Failed to load the sqljdbc_auth.dll cause : C:\Program Files (x86)\Java\jdk1.8.0_60\jre\bin\sqljdbc_auth.dll: Can't load AMD 64-bit .dll on a IA 32-bit platform
2017-08-25 18:50:12,524 [3190709] WARN - urce.DatabaseConnectionManager - Connecting to: jdbc:sqlserver://localhost; instancename=SQLEXPRESS;integratedSecurity=true;
2017-08-25 18:50:12,524 [3190709] WARN - urce.DatabaseConnectionManager - [08S01] This driver is not configured for integrated authentication. ClientConnectionId:7a3526a5-bf30-41d9-8f5b-de4bc4d503d1
2017-08-25 18:50:12,524 [3190709] WARN - lij.database.util.ErrorHandler - This driver is not configured for integrated authentication. ClientConnectionId:7a3526a5-bf30-41d9-8f5b-de4bc4d503d1
java.sql.SQLException: This driver is not configured for integrated authentication. ClientConnectionId:7a3526a5-bf30-41d9-8f5b-de4bc4d503d1
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2400)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:68)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3132)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:43)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3123)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1981)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)
at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:27)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:323)
at sun.rmi.transport.Transport$1.run(Transport.java:200)
at sun.rmi.transport.Transport$1.run(Transport.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$256(TCPTransport.java:683)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:276)
at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:253)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:162)
at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:227)
at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:179)
at com.sun.proxy.$Proxy146.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intellij.execution.rmi.RemoteUtil.invokeRemote(RemoteUtil.java:175)
at com.intellij.execution.rmi.RemoteUtil.access$300(RemoteUtil.java:36)
at com.intellij.execution.rmi.RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:280)
at com.sun.proxy.$Proxy147.connect(Unknown Source)
at com.intellij.database.dataSource.DatabaseConnectionEstablisher.connect(DatabaseConnectionEstablisher.java:172)
at com.intellij.database.dataSource.DatabaseConnectionEstablisher.tryConnect(DatabaseConnectionEstablisher.java:111)
at com.intellij.database.dataSource.DatabaseConnectionEstablisher.lambda$establishConnection$1(DatabaseConnectionEstablisher.java:63)
at com.intellij.database.dataSource.AsyncUtil.lambda$null$4(AsyncUtil.java:48)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$12(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$13(AsyncUtil.java:137)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:500)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:94)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:137)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$5(AsyncUtil.java:48)
at java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:981)
at java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2124)
at java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:110)
at com.intellij.database.dataSource.DatabaseConnectionEstablisher.establishConnection(DatabaseConnectionEstablisher.java:53)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.supplyAsync(DatabaseConnectionManager.java:380)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.createInner(DatabaseConnectionManager.java:320)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.lambda$sync$2(DatabaseConnectionManager.java:300)
at com.intellij.database.dataSource.AsyncUtil.withAsyncFriendly(AsyncUtil.java:163)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.sync(DatabaseConnectionManager.java:297)
at com.intellij.database.dataSource.DatabaseConnectionManager$Builder.sync(DatabaseConnectionManager.java:111)
at com.intellij.database.dataSource.DataSourceSyncManager.lambda$static$1(DataSourceSyncManager.java:39)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor$1.perform(DataSourceSyncManager.java:240)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.updateDatabaseInfo(DatabaseModelLoader.java:288)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.run(DatabaseModelLoader.java:271)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor.performSync(DataSourceSyncManager.java:242)
at com.intellij.database.dataSource.AsyncUtil.lambda$null$6(AsyncUtil.java:54)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$12(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$13(AsyncUtil.java:137)
at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:548)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:493)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:94)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:137)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$7(AsyncUtil.java:54)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
at com.intellij.openapi.application.impl.ApplicationImpl$2.run(ApplicationImpl.java:343)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.UnsatisfiedLinkError: C:\Program Files (x86)\Java\jdk1.8.0_60\jre\bin\sqljdbc_auth.dll: Can't load AMD 64-bit .dll on a IA 32-bit platform
Hi,
> From reading elsewhere I gather this is likely because the sqljdbc_auth.dll file is not being found or is mismatched with something. I have copied the sqljdbc_auth.dll to everywhere I can see suggested:
> C:\windows\system32
> C:\Program Files (x86)\Java\jdk1.8.0_60\bin
> C:\Program Files (x86)\Java\jdk1.8.0_60\jre\bin
> C:\Program Files (x86)\Java\jre1.8.0_60\bin (I have jre1.8.0_66 on my machine but it does not have a bin folder just a lib one)
>C:\Program Files (x86)\JetBrains\IntelliJ IDEA 2017.1\jre64\bin
> I have included the first 3 of the above locations in my system variables Path statement (but none of them are in my user variables Path statement)
So, you mismatched x32 driver and x64 auth.
If you remove all mentioned paths from your environment variables (PATH) it should be working. Since we provide provide proper driver and sqljdbc_auth.dll.
Thank you.
Thanks
I tried switching to the x86 auth and that seems to have fixed the problem.
I appreciate the responses.
@ Dougrimmer
Hi,
That's great.
Thank you.