Product Knowledge Base

Space shortcuts

Page tree

Set up a domain account during installation

FEATURE AVAILABILITY STARTING FROM RELEASE 1.11.3

SET-97 - Getting issue details... STATUS

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:

 SQLException: Login failed for user 'DOMAIN\USER'

The given userid that is used by this connection presents itself as a SQL\USER account, instead of a DOMAIN\USER account.

A check on the SQL Server indicates that the given userid that was used to establish the connection presents itself as a SQL\USER account, instead of a DOMAIN\USER account.
You can continue the set-up but the database tables will not be created and the JobScheduler doesn't start.

Follow these steps to fix the problem after the set-up

  • edit $SCHEDULER_DATA/config/sos_settings.ini

    for MSSQL JDBC driver add IntegratedSecurity=true
     url = jdbc:sqlserver://[servername]:1433;IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]
    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

    for MSSQL JDBC driver add IntegratedSecurity=true
     db = jdbc -class... jdbc:sqlserver://[servername]:1433;IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename] -user=... -password=...
    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

for MSSQL JDBC driver add IntegratedSecurity=true
 <property name"hibernate.connection.url">jdbc:sqlserver://[servername]:1433;IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]</property>
for jTDS JDBC driver add domain=<domainname>
 <property name"hibernate.connection.url">jdbc:jtds:sqlserver://[servername]:1433;domain=[domainname];sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]</property>