Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-107

JobScheduler Windows Update Setup and MSSQL Integrated security

    XMLWordPrintable

Details

    • Fix
    • Status: Dismissed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.11
    • 1.11.5, 1.12
    • None

    Description

      Current Situation

      Following error can occur while JobScheduler Update if MSSQL JDBC connection using Integrated security:

      ... the JobScheduler database management system is mssql
... create JobScheduler database tables which not already exist
... error occurred while executing install:
java.sql.SQLException: com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNUNG: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path
Exception in thread "main" java.lang.Exception: connect to database failed: sos.connection.SOSMSSQLConnection.connect(112): com.microsoft.sqlserver.jdbc.SQLServerException: This driver not configured for integrated authentication
...

      Desired Behaviour

      Updating JobScheduler Windows with the configured MSSQL Integrated security should work without error.

      Maintainer Note

      sqljdbc_auth.dll has to be located in the Path(e.g. C:\Windows\System32 or in the .\bin directory of the JDK or JRE in use)

      Attachments

        Activity

          People

            oh Oliver Haufe
            re Robert Ehrlich
            Robert Ehrlich Robert Ehrlich
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: