Content Server Manual / Version 2210
Table Of Contents
For the SQL Server database you must use the original JDBC driver supplied by Microsoft.
It is available at https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc.
Pick the latest version, and add the dependency to the database-drivers pom.xml,
like this:
<!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc -->
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>12.1.0.jre11-preview</version>
</dependency>
You should delete all other dependencies in database-drivers.
They do not harm, but you do not need them, and libraries always bear
the risk of introducing security vulnerabilities.
Moreover, configure the following settings:
sql.store.driver= com.microsoft.sqlserver.jdbc.SQLServerDriver sql.store.url=jdbc:sqlserver:// <DB-HOST>:<DB-PORT>;databaseName=<DB-NAME> sql.store.user=<DB-USER> sql.store.password=<DB-USER-PASSWORD>
Only SQL Server authentication is supported for the database user.
Caution
The DB user must not be a DBA or owner of the database otherwise all objects are created in the wrong (dba)
schema. Roles db_datareader, db_datawriter and db_ddladmin are
sufficient as the rights for the database user.


