This will not honor the JavaKerberos setting and you will get the error listed above. Using Kerberos Integrated Authentication to Connect to SQL ServerĪnother aspect that was discovered was the that it appears that the WebSphere 8.5 release comes with the 3.0 version of the SQL JDBC Driver. The following document outlines how to use Kerberos with the JDBC Driver and walks through what is needed to get JavaKerberos working properly. In the third case, even if you specify authenticationScheme=JavaKerberos, it won’t help as the older drivers aren’t aware of it, so it is ignored. , you are using a version of the JDBC Driver prior to the 4.0 driver and trying to use Integrated Authentication on a Unix/Linux platform. , you specified integratedSecurity and omitted authenticationScheme, which defaulted to NativeAuthentication, and you are on a Unix/Linux Platform. , you actually specified authenticationScheme=NativeAuthentication in your connection string and you are on a Linux Platform. So, if you are receiving the error above, there are three possibilities that could be causing it to show up. This is java specific and not bound to the underlying operating system, so this can be used on both Windows and Linux platforms. – Makes use of the Java API’s to invoke kerberos and does not rely on the Windows Platform. This was the only option prior to the JDBC 4.0 driver. (default) – This uses the sqljdbc_auth.dll and is specific to the Windows platform. Starting in the JDBC 4.0 driver, you can use the authenticationScheme connection property to indicate how you want to use Kerberos to connect to SQL. It is when we are trying to use Kerberos and the Authentication Scheme is set to NativeAuthentication, which is the default setting for this property. There is only one location within the JDBC Driver where this particular error is raised.

The last one I worked on was running WebSphere 8.5. Specifically they were running WebSphere on a Linux platform.

The key environment point on this was that they were trying to do this on a Linux platorm and not a Windows platform.

: This driver is not configured for integrated authentication I’ve had about 4 cases in the last two months that centered around the following error when trying to use Windows Integrated authentication with JDBC.

Microsoft sql server jdbc driver type 4