aspose file tools*
The moose likes JDBC and the fly likes Problem in connecting to SQL server using jtds driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in connecting to SQL server using jtds driver" Watch "Problem in connecting to SQL server using jtds driver" New topic
Author

Problem in connecting to SQL server using jtds driver

Rituparna Duttagupta
Ranch Hand

Joined: Feb 08, 2011
Posts: 55

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?


With regards,
rituparna
Arkadiusz Hahn
Greenhorn

Joined: Apr 28, 2011
Posts: 3

To make windows authentication work, You need to put the ntlmauth.dll on your system.
Rituparna Duttagupta
Ranch Hand

Joined: Feb 08, 2011
Posts: 55

thanks for this information.
but from where can i get this file?
Arkadiusz Hahn
Greenhorn

Joined: Apr 28, 2011
Posts: 3

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem in connecting to SQL server using jtds driver