Try using the domain=<domainname> option and provide your domain username and password. jdbc:jtds:sqlserver:// <servername>;instance=<instancename>;domain=<domainname>
Setup server authentication if your domain password changes frequently. Other thoughts Are you using the latest jTDS driver? 1.2.4 - although all versions have worked in my experience Do you use more than one SQL server instance? jdbc:jtds:sqlserver://<servername>;instance=<instancename> On Nov 29, 4:13 am, Louis Tiao <[email protected]> wrote: > Hi everyone, > > I am currently trying to establish a connection to SQL Server 2005 > with my jTDS JDBC Driver in NetBeans IDE 6.7.1. I want to do this > through Windows authentication so I left Username and Password field > blank. This now returned the following error: > > Unable to add connection. Cannot establish a connection to > jdbc:jtds:sqlserver://<myserver>:1433/<mydatabase> using > net.sourceforge.jtds.jdbc.Driver (I/O Error: SSO Failed: Native SSPI > library not loaded. Check the java.library.path system property.). > > It seems like I am missing some .dll file in a certain directory but I > can't determine which file and which directory. > > This is getting really annoying. I can't seem to find the right > answers on Google. > > Please help! > > Regards, > Lou -- To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/javaprogrammingwithpassion?hl=en
