Using windows authentication with sqljdbc.jar

jdbc websphere jtds
Ayusman picture Ayusman · Aug 4, 2011 · Viewed 10.5k times · Source

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

blob picture blob · Aug 4, 2011

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

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

Related questions

How to Setup an Oracle JDBC Data Source on WebSphere Application Server 7 Step-by-Step

How do you setup an Oracle JDBC data source on WebSphere Application Server 7 using Admin Console?

Read More
WebSphere to Oracle - doesn't accept correct password

In WebSphere 6.1 I have created a datasource to an Oracle 11g instance using the thin JDBC client. In Oracle I have two users, one existing and another newly created. My websphere datasource is OK if I use the component-managed authentication …

Read More
Resource reference with name 'jdbc/devl' not found in ibm-web-bnd.xml

RAD 7, WebSphere 7. ibm-web-bnd.xml: <resource-ref name="jdbc/devl" binding-name="jdbc/devl" /> web.xml: <resource-ref> <res-ref-name>jdbc/devl</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Application</…

Read More