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.