ns am writing a "server-side extension" because that SmartFoxServer (SFS). In my login script, I must make a link to multiple sclerosis SQL Server, which ns am attempting to perform using JDBC. I have actually tested the JDBC code in mine debug environment, and it functions fine.

You are watching: This driver is not configured for integrated authentication

BUT

When I placed the server-side expansion in the SFS "extensions" folder (as per spec), I"m getting a com.microsoft.sqlserver.jdbc.SQLServerException:

"This driver is not configured for combined authentication.".

I Googled for this error, and found that it"s usually due to the fact that the paper sqljdbc_auth.dll is not in the device path; ns have replicated this document into a folder in my mechanism path, and still that does not work!

Any various other suggestions?


java sql-server jdbc mssql-jdbc smartfoxserver
re-publishing
improve this question
monitor
edited Sep 5 "19 in ~ 15:27
*

A jar of Clay
3,79133 gold badges2222 silver badges3535 bronze title
asked might 22 "11 at 12:08
*

Shaul BehrShaul Behr
34.8k6262 gold badges236236 silver- badges363363 bronze title
include a comment |

11 answers 11


active earliest Votes
35
When utilizing Windows Authentication integrated Security

Download the sqljdbc_6.0.8112.100_enu.exe from Microsoft SiteInstall the exe (read the instructions in the zip path)

copy sqljdbc_4.0/enu/auth/x64/sqljdbc_auth.dll to

Java/jre7/bin and to

Java/jre7/lib

After this youj need to be may be to affix to hibernate devices to traction the database in Data Tools


share
improve this answer
follow
answered Aug 21 "17 at 17:20
*

PavanPavan
1,51111 gold badge1515 silver badges1717 bronze badges
3
add a comment |
26
There are various versions the sqljdbc_auth.dll for different processor architectures (x86/x64/ia64). I m sorry one space you utilizing on her SFS server?

You must pick the one to match the design of the JVM under which SFS is running. So, if you"re to run 32-bit Java top top a 64-bit machine, you"ll require the x86 version, not the x64 version.

I"ve not provided SFS before, so ns don"t understand whether that writes any kind of logs anywhere. If it does, it could be worth acquisition a look at at this logs to view if anything helpful has been written to them.

EDIT: ns can"t be 100% certain that SFS is utilizing 64-bit Java just due to the fact that it runs the end of C:Program records as protest to C:Program papers (x86).

I found the following line in the SFS docs under advent > Requirements and Installation. Whilst this line applies only to Linux as opposed to Windows, it can suggest that SFS ~ above Windows additionally uses 32-bit Java:

Since version 1.5 SmartFoxServer comes v its very own x86 32-bit sun Java Runtime.

One quick method to recognize which version(s) the Java you have installed is, provide the following command in her cmd: Java -version

It will screen the complying with to the console:

C:Users967097>java -versionjava version "1.8.0_131"Java(TM) SE Runtime environment (build 1.8.0_131-b11)Java HotSpot(TM) 64-Bit Server VM (build 25.131-b11, combined mode)Here,you deserve to see the bit form of the java version installed.

Does her application work-related if you usage the x86 version of sqljdbc_auth.dll rather of the x64 version? If it suddenly starts working v the x86 DLL, then SFS have to be using 32-bit Java.

Is there a batch-file provided to begin SFS? If so, reading through the might assist point out whereby SFS is to run Java from. Likewise look out for any changes come the PATH. Java can only pack DLLs in the java.library.path mechanism property, and also on Windows, this is collection to the worth of the PATH setting variable.

See more: How To Make A Rainbow Beacon In Minecraft Rainbow Beacon : 3 Steps

If you still can"t recognize whether SFS is making use of 32-bit or 64-bit Java, try using process Explorer to look in ~ the environment that the java.exe procedure running SFS was began with.