DB011/DB02 - How to configure the 360 Web Platform database with SQL Server AD Domain account

DB011/DB02 - How to configure the 360 Web Platform database with SQL Server AD Domain account

Symptom

When configuring the database in the Web Platform Administration Console with a AD Domain account for SQL Server, you encounter one of the following errors :
- DB012: Could not find driver
- DB011: This driver is not configured for integrated authentication,

Environment

  • Web Platform
  • Windows
  • Linux
  • SQL Server

Cause

The Web Platform Tomcat service account must be the SQL Service Domain account that accesses the database.
The JTDS driver must be used and the JDBC URL must contain useNTLMv2=true and domain=yourdomain

Resolution

1. Set up the JTDS driver

  1. Download the latest JTDS driver from: https://sourceforge.net/projects/jtds/
  2. Unzip the package and copy-paste the jtds-1.x.x.jar in a location where it will not be deleted.
  3. During the installation (or update, if an existing installation) of the Web Platform, when the wizard prompts to enter the JDBC location for the database, click Browse to select the jtds-1.x.x.jar file.


2. Set up the Tomcat Service Account

  1. Stop the Web Platform Tomcat Service (360Suite4xxx).
  2. Under the Log On properties, click Browse to enter/select the SQL Service AD Domain account.
  3. Click OK.


3. Retrieve the ntlmauth.dll file

  1. The file is available in the JTDS driver package downloaded from: https://sourceforge.net/projects/jtds/ and unzipped.
  2. Depending on the deployment and JVM architecture, select either the 32-bit (x86) or the 64-bit (x64) version. NB: The Java shipped with the Web Platform TOmcat is 64-bit.
Note: the JVM provided as part of the 360 Web Platform installation package is 64-bit. If you're unsure, then use the following steps to find out the version and architecture of Java used.



4. Add the Microsoft DLLs to the Web Platform Java location

  1. Take a copy of the ntlmauth.dll (for x64) and a copy of the mssql-jdbc_auth-9.4.1.x64.dll. The latter file can be obtained by download the MS SQL JDBC driver package
  2. Paste them in the location 360Suitexxx/jdk8[...]/bin

5. Configure the Web Platform database

  1. Access the 360Suite Administration Console: http://<server>[:<port>]/360.suite/admin
  2. In the “Database configuration“ block, configure as follows:
    Database: SQL Server (then, select the appropriate version).
    URL: jdbc:jtds:sqlserver://<server>:<port>/<database_name>;useNTLMv2=true;domain=<domain_name>
    Windows Authentication: Selected.
    Advanced configuration: Not selected.
  3. Click Save.


Keywords

integrate security Azure

Product

Product or Product version

  • 360 Web Platform

Languages

  • English US
  • English UK
  • French