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.


