Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
If you connect to the MSSQL server with a Windows DOMAIN\USER account then it could be that you get an error during the setup:
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:
Code Block |
---|
Code Block |
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
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
No Format urlh1. jdbc(:jtds):sqlserver://[servername]:1433;<span style"color:red">IntegratedSecurith1. true;</span>sendStringParametersAsUnicodefalse;selectMethoh1. 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 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=... -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=... -passworh1. 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> |