Content Server Manual / Version 2101
Table Of Contents
For the SQL Server database you must use the original JDBC driver supplied by Microsoft. Copy the driver file
into the lib
directory of the Content Server
and 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.