Using windows authentication with sqljdbc.jar

Question

Is it possible to use the windows authentication mode for SQL SERVER database, while using the micro soft provided JDBC drivers?

I am using sqljdbc.jar.. the SQLJdbcVersion class file contains this:

  static final int major = 2;
  static final int minor = 0;
  static final int MMDD = 1803;
  static final int revision = 100;

Any comments?

Is there a reason why sqljdbc can not use windows authentication?

I am using Websphere application server 7 and running a j2ee application. The datasources are created in the WAS itself.

Thanks

Answer 1

Yes you can use windows authentication with JDBC driver provided by Microsoft

jdbc:sqlserver{HOST};Database={DB_NAME};integratedSecurity=true