Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in connecting to SQL server using jtds driver

 
Rituparna Duttagupta
Ranch Hand
Posts: 55
Firefox Browser Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello everyone,
I am having a connection problem in my web application. I was trying to connect to sql 2008 server using jtds driver and getting the following error:
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

I've gone through the previous posts discussing the topic, which says that one should go for SQL server authentication instead of Windows authentication to connect to the server.
My question is-
why is it that we cant use the windows authentication? Is SQL server authentication the only way available?
Earlier, when i used the JdbcOdbcDriver, it was ok to use the Windows authentication, everything's worked alright.

Does it has anything to do with the driver used?
 
Arkadiusz Hahn
Greenhorn
Posts: 3
C++ Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
To make windows authentication work, You need to put the ntlmauth.dll on your system.
 
Rituparna Duttagupta
Ranch Hand
Posts: 55
Firefox Browser Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks for this information.
but from where can i get this file?
 
Arkadiusz Hahn
Greenhorn
Posts: 3
C++ Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download
It is inside the package
jtds-1.2.5-dist.zip\x86\SSO\ntlmauth.dll
Have you read README.SSO file ?
Bye.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic