Issue connecting to MS SQL Server DB using JTDS driver on JBOSS EAP 6.4.8

[ritesh.negi]

Hi,

We are migrating our application from IBM WebSphere to JBOSS EAP 6.4.8.

We are trying to connect to MS SQL server using JTDS driver and are getting the below error.

Failure trying to get a pooled connection to [jdbc:jtds:sqlserver://NNN.NNN.NNN.NNN:1433;databaseName=<DB>;integratedSecurity=true;authenticationScheme=JavaKerberos;Domain=ADS;useNTLMv2=TRUE]java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

We are unable to figure out the issue.

We have tried different combination of the connection string variables but have had no success.

In IBM WebSphere environment, we are using jtds-1.2.5.jar driver and in JBOSS EAP 6.4.8, we are using jtds-1.3.1.jar driver.

Has anyone worked with JTDS driver and faced any such error?

[pjhavariotis]

First of all you have to know that according to the JBoss Enterprise Application Platform (EAP) 6 Supported Configurations the JTDS driver has not been tested or certified in JBoss EAP.

Furthermore, according to your connection URL, you are trying to connect via Java Kerberos to a MS SQL database. I assume that you have already created a suitable JAAS configuration for this.