Sql Server - connect with windows authentication

Question

Hello,

i must connect to a sql server with windows authentication

sql server is on machine 192.168.3.6 web server (client) is on my machine 192.168.3.10

I'm using JTDS driver

dbUrl=jdbc:jtds:sqlserver://192.168.3.6:1099/db_test;instance=test Connection con = DriverManager.getConnection( dbUrl, "", "" );

I have username and password of administrator user of sql server !

I also put ntlmauth.dll into c:\windows and c:\windows\system32 and I have always error

java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Any idea to solve my problem ? Thank you very much

Answer 1

Try this http://www.ehow.com/how_5232278_create-trusted-sql-server-connection.html

Answer 2

See jTDS FAQ http://jtds.sourceforge.net/faq.html

you will have to pass useNTLMv2=true and domain=yourdomain

Answer 3

I have not a domain ! Is it possible solve this problem ?