The database configuration for JID is defined in $scheduler_data/config/hibernate.cfg.xml
- Open the file $scheduler_data/config/hibernate.cfg.xml
- Identify the property name hibernate.connection.url
- Change it as specified here
<property name="hibernate.connection.url">jdbc:sqlserver://servername:1433;IntegratedSecurity=true; sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=databasename</property>
- Locate the file "sqljdbc_auth.dll" from the "auth" subfolder of the Microsoft JDBC Driver folder (use either the x86 or x64 version depending on your version of the JVM);
- Copy this file into a folder <apath>
- Open the file '$scheduler_home/user_bin/dashboard_environment_variables.cmd
- If this file does not exist, rename the file dashboard_environment_variables.cmd-example to dashboard_environment_variables.cmd
- Add the line set JAVA_OPTIONS=-Djava.library.path<apath> -Xms128m -Xmx256m at the end of the file.