Page History

If you connect to the MSSQL server wanted to use a connection to a SQL Server for JobScheduler with a Windows DOMAIN\USER domain account then it could be happen that you get receive an error during the setupset-up:

 SQLException: Login failed for user 'DOMAIN\USER'

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

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

Follow this step these steps to fix it the problem after the setup:set-up

• edit $SCHEDULER_DATA/config/sos_settings.ini

  No Format
  url urlh1.= jdbc(:jtds):sqlserver://[servername]:1433;<span style"color:red">IntegratedSecurith1. true;</span>sendStringParametersAsUnicodefalse;selectMethoh1. IntegratedSecurity=true;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

  No Format
  db h1.= jdbc -class... jdbc(:jtds):sqlserver://[servername]:1433;<span stylh1. "color:red">IntegratedSecuritytrue;</span>sendStringParametersAsUnicodh1. false;selectMethodcursor;databaseNamh1. IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename] -user=... -passworh1. password=...

• edit $SCHEDULER_DATA/config/hibernate.cfg.xml

  No Format
  <property name"hibernate.connection.url">jdbc(:jtds):sqlserver://[servername]:1433;<span stylh1. "color:red">IntegratedSecuritytrue;</span>sendStringParametersAsUnicodh1. false;selectMethodcursorIntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=[databasename]</property>