I am writing a "server-side extension" for SmartFoxServer (SFS). In my login script, I need to make a connection to MS SQL Server, which I am attempting to do using JDBC. I have tested the JDBC code in my debug environment, and it works fine.
BUT
When I put the server-side extension in the SFS "extensions" folder (as per spec), I'm getting a com.microsoft.sqlserver.jdbc.SQLServerException
:
"This driver is not configured for integrated authentication.".
I Googled for this error, and found that it's usually because the file sqljdbc_auth.dll
is not in the system path; I have copied this file into a folder in my system path, and still it does not work!
Any other suggestions?
When using Windows Authentication Integrated Security
copy sqljdbc_4.0/enu/auth/x64/sqljdbc_auth.dll to
Java/jre7/bin and to
Java/jre7/lib
After this youj should be able to connect to hibernate tools to pull the database in Data Tools