Content Server Manual / Version 2406.0
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.