close

Filter

loading table of contents...

Content Server Manual / Version 2207

Table Of Contents

3.2.3 Microsoft SQL Server

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

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
warning

Your Internet Explorer is no longer supported.

Please use Mozilla Firefox, Google Chrome, or Microsoft Edge.