AP

I am able to connect to the SQL server using user name & password from our application with kerberos authentication. But our customer prefers to use keytab file instead of passing the password over the network. When I try to use keytab I am facing some issues as below. Our SQL server's SPN is: MSSQLSvc/myhost:1433@MYDOMAIN.COM I have created keytab file as: ktpass -out "C:\Users\myuser\KerberosConf\MSSQL\myappserver.keytab" -princ MSSQLSvc/myhost:1433@MYDOMAIN.COM -mapUser mydomain\myuser-pass Test@123...

I am using below code with jtds-1.3.1.jar and getting some error try { String filePath = System.getProperty("user.dir") + File.separator + "KerberosConfDir"; Driver d = (Driver)Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); System.setProperty("java.security.krb5.debug", "true"); System.setProperty("java.security.auth.login.config", filePath+File.separator+"login.conf"); System.setProperty("java.security.krb5.conf", filePath+File.separator+"krb5.ini"); System.setProperty("javax.security.auth.useSubjectCredsOnly",...

I am using below code with jtds-1.3.1.jar and getting some error try { String filePath = System.getProperty("user.dir") + File.separator + "KerberosConfDir"; Driver d = (Driver)Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); System.setProperty("java.security.krb5.debug", "true"); System.setProperty("java.security.auth.login.config", filePath+File.separator+"login.conf"); System.setProperty("java.security.krb5.conf", filePath+File.separator+"krb5.ini"); System.setProperty("javax.security.auth.useSubjectCredsOnly",...

I am using below code with jtds-1.3.1.jar and getting some error try { String filePath = System.getProperty("user.dir") + File.separator + "KerberosConfDir"; Driver d = (Driver)Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); System.setProperty("java.security.krb5.debug", "true"); System.setProperty("java.security.auth.login.config", filePath+File.separator+"login.conf"); System.setProperty("java.security.krb5.conf", filePath+File.separator+"krb5.ini"); System.setProperty("javax.security.auth.useSubjectCredsOnly",...

I am using below code with jtds-1.3.1.jar and getting some error try { String filePath = System.getProperty("user.dir") + File.separator + "KerberosConfDir"; Driver d = (Driver)Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); System.setProperty("java.security.krb5.debug", "true"); System.setProperty("java.security.auth.login.config", filePath+File.separator+"login.conf"); System.setProperty("java.security.krb5.conf", filePath+File.separator+"krb5.ini"); System.setProperty("javax.security.auth.useSubjectCredsOnly",...

Can anyone respond to this? I am in need of the same..

Can someone help me in which version of JTDS jar , the kerberos support was added? I am checking through many posts but still I could not get a clear info. Also if possible please post a sample code of kerberos in JTDS. Appreciating your help! Thanks

Hi Ringo, Did you get any solution on this issue? Thanks -AP