Page History

Set up a domain account during installation

Uses can create their own hibernate configuration file and cause the installer to use this file. The hibernate.connection.url property in this file should include the IntegratedSecurity=true setting

Set up a domain account for an existing JobSchedule installation

If you wanted to use a connection to a SQL Server for JobScheduler with a Windows domain account then it could happen that you receive an error during set-up:

...

• edit $SCHEDULER_DATA/config/sos_settings.ini

  Code Block
  title for MSSQL JDBC driver add IntegratedSecurity=true
  url = jdbc:sqlserver://[servername]:1433;IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]

  Code Block
  title for jTDS JDBC driver add domain=<domainname>
  url = jdbc:jtds:sqlserver://[servername]:1433;domain=[domainname];sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]

  Then start $SCHEDULER_HOME\install\scheduler_install_tables.cmd to create the database tables.

   

• edit $SCHEDULER_DATA/config/factory.ini

  Code Block
  title for MSSQL JDBC driver add IntegratedSecurity=true
  db = jdbc -class... jdbc:sqlserver://[servername]:1433;IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename] -user=... -password=...

  Code Block
  title for jTDS JDBC driver add domain=<domainname>
  db = jdbc -class... jdbc:jtds:sqlserver://[servername]:1433;domain=[domainname];sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename] -user=... -password=...

edit $SCHEDULER_DATA/config/hibernate.cfg.xml

 <property name"hibernate.connection.url">jdbc:sqlserver://[servername]:1433;IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]</property>

 <property name"hibernate.connection.url">jdbc:jtds:sqlserver://[servername]:1433;domain=[domainname];sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]</property>

...