Content Server Manual / 3.2.3 Microsoft SQL Server

Advanced Search

loading table of contents...

Content Server Manual / Version 2201

Table Of Contents

3.2.3 Microsoft SQL Server

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

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.

Search Results

Table Of Contents