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:sq

Solution 1:

sqljdbc_auth.dll is need to use windows authentication or Kerberos authentication.

Get the dll from Microsoft and install it either by:

1. drop on application library folder
2. drop on the java bin folder (attention if you have multiple java installations)

3. drop the library on some folder and then add the path in the command line:

   java -Djava.library.path=<library path>...
   

The mssql-jdbc driver and the auth dll should be:

• on the same folder (but not mandatory)
• both from the same version
• for the same architecture (x86/x64) JVM is running.

Check also the jdbc compatibility matrix with java versions on the download page.

Solution 2:

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!

Solution 3:

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