I'm trying to get the SQL Developer to connect to a SQL Server instance. I keep getting this error:
Status : Failure -Test failed: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
I have put the ntlmauth.dll file in many places. It is still not working.
I have data modeler x64 4.0.1-836
The jtds is jtds-1.3.1-dist
I'm using Windows 8, connecting to SQL Server 2012
Can anyone tell me where the SQL Developer will look for this file? Where should I put it?
C:\Program Files (x86)\Java\jre7\bin
I finally got the connection to SQL Server to work by doing the following:
Took the ntlmauth.dll in the jtds-1.3.1-dist\x64\SSO folder and put it into the datamodeler\jdk\jre\bin folder
Restart SQL Developer Data Modeler
Putting the x64 bit ntlmauth.dll into the datamodeler\jdk\jre\bin folder fixed the problem.