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?

3 Replies

Related Content

Git Authentication - no 'Connect' button

JDBC connectivity issue - No matching authentication protocol

Project Authentication

Kafka topic using OAuth2 authentication

Connection reset

Recent Discussions

Mismatch between response from a CURL request and ReadyAPI response

Reading dynamic parameter from resource path

Parameterising JDBC Connection Settings..Can you do it?

Test Runner - Report All in One File

GroovyScript Help - Repeating JSON Attributes Have Specific Value.....some of the time?