CoreMedia Content Server Manual, Version 7.5.45-10
3.3. Configuring the Database | 3.3.4. Microsoft SQL Server

For the SQL Server database you must use the original JDBC driver supplied by Microsoft. Copy the driver file into the WEB-INF/lib directory and configure the following settings in the file sql.properties:

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.