Configuring SQL Server JDBC Driver with Windows Authentication

Ambience 202x
,
1

This entry explains how to set up the Microsoft JDBC driver for SQL Server with Windows Integrated Authentication. It covers when the mssql-jdbc_auth DLL is required, where to place it, and how to confirm successful authentication.

Configuration Steps

  1. Obtain the latest driver package (e.g., sqljdbc_13.4.0.0_enu) and extract the contents.

  2. Deploy the sqljdbc driver in the \lib or \ext directory of the Ambience/Repertoire 202x installation

  3. Locate the Authentication DLL, by default it will be in:

    sqljdbc_13.4\enu\auth\x64\mssql-jdbc_auth-13.4.0.x64.dll

    (Use x64 for 64‑bit JVM, x86 for 32‑bit JVM)

  4. Copy the DLL into C:\Windows\System32 (for 64‑bit JVM). Alternatively, add the folder path to your PATH environment variable.

  5. Go to \etc directory, make a copy and rename hikari-sample.properties, e.g. mssqlwinauth.properties. Edit the mssqlwinauth.properties file as follows:

dataSourceClassName=com.microsoft.sqlserver.jdbc.SQLServerDataSource
dataSource.databaseName=<dbname>
dataSource.portNumber=<port>
dataSource.serverName=<servername>
dataSource.url=jdbc:sqlserver://servername:port;databaseName=dbname;integratedSecurity=true;encrypt=true;trustServerCertificate=true;
  • integratedSecurity=true → enables Windows Authentication.
  • encrypt=true → enforces SSL/TLS encryption.
  • trustServerCertificate=true → bypasses certificate chain validation (useful for self‑signed certs).
  1. Edit application.conf to point to the new MSSQL connection properties file.
elixir.data.jdbc {
  connection-pool {
    implementation = "hikari"
    loader = "ambience.etl.jdbc.DefaultConnectionPoolLoader"
    definition {
      mssqlwinauth="./etc/mssqlwinauth.properties"
    }
  }
}
  1. Save and restart your Ambience/Repertoire server. The driver will load the DLL and authenticate using the Windows account running the process.