Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Set up a domain account during installation
Display feature availability | ||
---|---|---|
|
Jira | ||||||||
---|---|---|---|---|---|---|---|---|
|
Users can create their own hibernate configuration file and make the installer use this file. The hibernate.connection.url
property in this file should include the IntegratedSecurity=true setting, no user name and password are specified. This configuration will implicitly use the domain account that the JobScheduler Master / Agent is running for.
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 noformattitle for jTDS JDBC driver add domain=<domainname> url = jdbc(:jtds):sqlserver://[servername]:1433;IntegratedSecuritydomain=true[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 noformattitle for jTDS JDBC driver add domain=<domainname> db = jdbc -class... jdbc(:jtds):sqlserver://[servername]:1433;IntegratedSecuritydomain=true[domainname];sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename] -user=... -password=...
edit $SCHEDULER_DATA/config/hibernate.cfg.xml
...
Code Block | ||
---|---|---|
| ||
<property name"hibernate.connection.url">jdbc:sqlserver://[servername]:1433;IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]</property>
|
Code Block | ||
---|---|---|
| ||
<property name"hibernate.connection.url">jdbc |
...
:jtds |
...
:sqlserver://[servername]:1433; |
...
domain= |
...
[domainname];sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]</property> |