If the JTDS driver shipped with RapidMiner Studio and Server for Microsoft SQL Server is used, the respective property name is
. This property must be set to “true”. Setting driver properties is possible via the “Advanced” button in RapidMiner Studio's connection editor dialog or via the “Advanced settings” when editing database connections in RapidMiner Server.
To apply this setting to the database connection used by RapidMiner Server for its internal data, modify the following line in the standalone/configuration/standalone.xml file in the RapidMiner Server installation directory for the RapidAnalyticsDS datasource element:
In order for this functionality to work properly, a platform dependent native library file needs to be installed. It can be obtained from http://sourceforge.net/projects/jtds/files/jtds/. Download the ZIP file, locate the file x86/SSO/ntlmauth.dll or x64/SSO/ntlmauth.dll, depending on your architecture, and copy it to a directory on the path, i.e. listed in the Windows %PATH% environment variable. A good candidate is also the bin folder of your Java Runtime installation. If you cannot copy it into a directory on the %PATH%, you need to edit the startup files of RapidMiner Server.
You can specify that directory by editing the file bin\standalone.conf.bat. The last line should read
Before that line, add a line saying
set JAVA_OPTS="%JAVA_OPTS% -Djava.library.path=yourPathToNtlmauth.dll"