JobScheduler Master Setup throws an error with NPE when using MSSQL integrated security.

Current Situation

When having a mssql database configured with integrated security
JobScheduler Master Setup fails with an npe error.

java.sql.SQLException: Exception in thread "main" java.lang.Exception: connect to database failed: Error occured creating connection object for class SOSMSSQLConnection: null

url                  = jdbc:sqlserver://sql_host:49554;IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler

Desired Behaviour

JobScheduler update should run without nullpointer exception when updating the database.

Workaround 1

Change the configuration file $scheduler_data/config/hibernate.cfg.xml. Use User/Password instead of integreated security.

Workaround 2

• configure empty username and password hibernate elements

  <property name="hibernate.connection.username"></property>
  <property name="hibernate.connection.password"></property>
  

• if This driver not configured for integrated authentication error occured:
  • copy sqljdbc_auth.dll into <JAVA>\bin or PATH location