Content Server Manual / Version 2412.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
and it is preconfigured in the database-drivers
pom.xml.
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.