This driver is not configured for integrated authentication

this driver is not configured for integrated authentication tomcat
this driver is not configured for integrated authentication datagrip
this driver is not configured for integrated authentication dbeaver
this driver is not configured for integrated authentication splunk
this driver is not configured for integrated authentication. mule 4
pentaho this driver is not configured for integrated authentication
sonarqube this driver is not configured for integrated authentication
gradle this driver is not configured for integrated authentication

Trying to connect my java web application with MS-SQL server using sqljdbc41 for jdk 1.8. Here is the database connection code-

    Connection connection;
    String url = "jdbc:sqlserver://localhost:1433;databaseName=Lista;integratedSecurity=true";
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    connection = DriverManager.getConnection(url);

when i am trying to insert some values to the database like-

    PreparedStatement ps = connection.prepareStatement("INSERT INTO user_informations VALUES(?,?,?)");

    ps.setString(1, "value");
    ps.setString(2, "value");
    ps.setString(3, "value");

    ps.executeUpdate();

getting the following error each time-

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication

Here are some informations about what i have tried yet-

  • i have added the path of sqljdbc41 in the path variable.
  • i have added the path of sqljdbc_auth.dll in the path variable.
  • i have added the sqljdbc41.jar into my Nebeans project library.
  • i have added the sqljdbc_auth.dll into both bin folder under jdk and jre.
  • my jdk is 64 bit under program files folder not in program file(x86).
  • jdbc driver folder is also in program file directory.
  • sql server and sql server browser services are also running.

Edit

Now i experiencing a new thing-after restarting my pc when i deploy the project for the first time then it is working perfectly but when i make any change in my code and re-run the project it's not working!

I solved my problem!

The error (described in my question above) i was getting because the glassfish server had not any access on sqljdbc42.jar file. so i have placed the sqljdbc42.jar file into my glassfish server in this location-

glassfish-4.1\glassfish\domains\domain1\lib

And it's now working perfectly.

Thank you everyone!

JDBC throwing "SQLServerException: This driver is not configured , sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication error. This Q&A is abstracted from an issue asked of IBM. "This driver is not configured for integrated authentication.". I Googled for this error, and found that it's usually because the file sqljdbc_auth.dll is not in the system path; I have copied this file into a folder in my system path, and still it does not work!

The problem for me was that there were 2 java installations, one of them was the standard installation and it was 64bit, the other one was included in my oracle jdeveoper installation (it was the one used by the application giving that error) and surprisingly it was 32bit. I just put the correct dll in the java installation used by my application and everything went well

"com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not , SQLServerException: This driver is not configured for integrated authentication. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(� java.sql.SQLException: This driver is not configured for integrated authentication The key environment point on this was that they were trying to do this on a Linux platorm and not a Windows platform. Specifically they were running WebSphere on a Linux platform. The last one I worked on was running WebSphere 8.5.

JDBC: This driver is not configured for integrated authentication , Third , you are using a version of the JDBC Driver prior to the 4.0 driver and trying to use Duration: 12:33 Posted: Jan 15, 2019 Fix: This Driver is Not Configured for Integrated Authentication – SQLJDBC After installing the Microsoft JDBC driver on your SQL server, you try to attempt to connect to the SQL server using Windows integrated authentication, but receive a connection error occurred. When you review the connection error log, you see a message similar to below.

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not , SQLServerException: This driver is not configured for integrated authentication. This generally indicates that the driver can not find the appropriate sqljdbc_auth. dll in the JVM library path. To correct the problem, please use the java.exe -D option to specify the "java. com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. Here are some informations about what i have tried yet-i have added the path of sqljdbc41 in the path variable. i have added the path of sqljdbc_auth.dll in the path variable. i have added the sqljdbc41.jar into my Nebeans project library.

This driver is not configured for integrated authentication, Hi, We need to connect to MSSQL database using windows authentication from JDBC driver. when i tried the same i am getting below error. 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.

[ Resolved ] SQL Error : This driver is not configured for integrated , This driver is not configured for integrated authentication, MSSQL, integratedSecurity=true, integratedSecurity, sqljdbc_auth.dll. I've tried installing the JDBC driver (.jar and .dll's) on a network drive that our software users have access to. I've pointed the class path to the folder where the driver is located. This works for me but when other users try to use the tool they get the following error: SQLException: This driver is not configured for integrated authentication.

Comments
  • Look at this link: JDBC 4.x: This driver is not configured for integrated authentication. ALSO: Are you running a 32-bit or 64-bit JVM? Exactly where did you get sqljdbc_auth.dll: from the 32-bit or 64-bit Windows folder?
  • i already saw this, but it wasn't helpful for me! i putted sqljdbc_auth.dll from program files directory. isn't it windows 64bit folder?
  • Have you looked at all the suggestions in stackoverflow.com/questions/17277001/dll-missing-in-jdbc ?
  • This answer help me stackoverflow.com/questions/10637585/…