How to configure JID to connect to a database with IntegratedSecurity

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 below:
   

 <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 <some_path>
• Open the file $SCHEDULER_HOME/user_bin/dashboard_environment_variables.cmd
  • If this file does not exist then rename the file dashboard_environment_variables.cmd-example to dashboard_environment_variables.cmd
• Add the line set JAVA_OPTIONS=-Djava.library.path<some_path> -Xms128m -Xmx256m to the end of the file.