Cannot create PoolableConnectionFactory (Login failed for 'userName') JTDS

[Asif Usman]

Hi All,

Need help to create a connection pooling for J2EE web application with MSSQL Server 2008 using JTDS.

Environment :
OS : Windows XP
Java : java version "1.7.0"
Tomcat : version 7.0

I had used JTDS to create connecction pooling.

Here is my context.xml file contents

  <Resource name="jdbc/DBase1" auth="Container"
            type="javax.sql.DataSource"  
            username="SYSTEM-INFO-001\abc" 
            password="xyz"
            driverClassName="net.sourceforge.jtds.jdbc.Driver" 
            url="jdbc:jtds:sqlserver://localhost/DBase1;integratedSecurity=true"
            maxActive="8" 
            />

and here is my web.xml contents

 <resource-ref>
    <description>DB Connection</description>
    <res-ref-name>jdbc/DBase1</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

and here is the Java code to create datasource

InitialContext ic = new InitialContext();
	DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/DBase1");
        Conncection con=ds.getConnection();

I am using Windows authentication mode.
I already put my jtds-1.2.5.jar file in WEB-INT\lib and TOMCAT\lib
and i put ntlmauth.dll in jdk1.7.0/bin and C:\windows\system32 folders.

When i run application its giving following error:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'SYSTEM-INFO-001\abc'.)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.velocity.util.DBPoolUtil.getConnection(DBPoolUtil.java:79)
	at com.velocity.dal.DriverViolationDAL.getDriverViolation(DriverViolationDAL.java:67)
	at com.velocity.bridge.DriverViolationBSL.getDriverViolation(DriverViolationBSL.java:35)
	at com.velocity.business.DriverViolationBLL.getDriverViolation(DriverViolationBLL.java:83)
	at org.apache.jsp.test_jsp._jspService(test_jsp.java:88)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:395)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:250)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:166)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Login failed for user 'SANAH-INFO-001\Asif'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)

Please help to resolve this error.

Thanks in Advance.
Asif

[Rob Spoor]

You can't connect using a domain / Windows account like that. With Microsoft's own driver you need to either use integrated security and use the current user's* credentials to login, or provide a database login. With JTDS it may be different; check http://stackoverflow.com/questions/167464/can-i-connect-to-sql-server-using-windows-authentication-from-java-ee-webapp

* Current user here means the user that's running Tomcat.