How to connect to SQL Server using Windows Authentication?

Question

I need to connect to SQL Server using Windows Authentication?Can any one please tell how to do this? Which jdbc driver can be used for this?

siking · Answer

Can't be done!http://support.microsoft.com/kb/313100#6

smartbear_suppo · Answer

You should be able to do this with a jTDS JDBC driver - http://jtds.sourceforge.net/
and http://stackoverflow.com/questions/167464/can-i-connect-to-sql-server-using-windows-authentication-from-java-ee-webapp

Let me know if this works.

Thanks,
Michael Giller
SmartBear Software

veera · Answer

Hello,&nbsp;Here are the steps I had followed to connect to SQL server through Windows Authentication and It is not working. Please help me if you can.&nbsp;1. Downloaded the jTDS driver and&nbsp;ntlmauth.dll&nbsp;file2. Placed the driver file in Ready API --&gt; bin --&gt; ext folder3. Placed the "ntlmauth.dll" file in Ready API --&gt; bin folder4. JDBC String used "jdbc:jtds:sqlserver://&lt;HOST:127.0.0.1&gt;:&lt;PORT:1433&gt;/&lt;DB&gt;;trusted_connection=yes"

Forum Discussion

How to connect to SQL Server using Windows Authentication?

Recent Discussions

downgrade to lower ready api version 3.40.1 from latest

Changing environment in Jenkins mid-test

How to add same endpoints with different methods?

Related Content

Git Authentication - no 'Connect' button

JDBC connectivity issue - No matching authentication protocol

Kafka topic using OAuth2 authentication