Documentation Center

Content Manager database server prerequisites

The Content Manager requires an Oracle or Microsoft SQL Server database. This topic lists the required and supported software for the Content Manager database. Note that The Content Manager database server runs on any operating system that supports the specific DBMS you choose to use. Refer to your database vendor documentation to learn which operating systems are supported.

Recommended prerequisites

RWS recommends one of the following database servers:
  • Oracle Server 19c (19.3) (Enterprise Edition)
  • Microsoft SQL Server 2019 (Standard Edition or Enterprise Edition)
  • Microsoft Azure SQL Database
  • AWS RDS-MSSQL 2019

If your implementation uses MSDTC, then you cannot use the Cloud database servers, that is, Azure or AWS RDS-MSSQL.

Supported Microsoft SQL Server databases

Content Manager supports the following Microsoft SQL Server databases.

Supported:
  • SQL Server 2019 (Standard Edition or Enterprise Edition)
Deprecated:
  • SQL Server 2017 (Standard Edition or Enterprise Edition)

Supported Oracle databases

Content Manager supports the following Oracle databases.

Supported:
  • Oracle Database 19c (19.3) (Enterprise Edition)
Deprecated:
  • Oracle 18c (18.3) (Enterprise Edition)

Supported Cloud-based databases

Content Manager supports the following Cloud-based databases.

Supported:

  • Microsoft Azure SQL Database
  • AWS RDS-MSSQL 2019
Microsoft Azure SQL Database is supported with the following setup:
Setup itemType
Service tierGeneral Purpose
Compute tierProvisioned compute
HardwareIntel computer (or cloud equivalent)
DatabaseSingle database
BackupsAutomated backups
Deprecated:
  • AWS RDS-MSSQL 2017

Cloud hosting

To host Tridion Sites databases in the Cloud, you can use the following hosting services:
  • Amazon RDS (Relational Database Services) (for Microsoft SQL Server)
  • Microsoft Azure

.NET

To install the Content Manager database on a Windows machine, Microsoft .NET Framework 4.8 or higher must be installed on that machine.

PowerShell database script prerequisites

To run PowerShell database scripts for databases on the Content Manager side, you require a machine that meets the following requirements:
PowerShell
You require Microsoft Windows PowerShell 5.1. You can download Microsoft Windows Management Framework 5.1, which includes Microsoft Windows PowerShell 5.1, from this location: http://aka.ms/wmf5download
Operating system
You require an operating system that supports both the required PowerShell software and any software for the database you intend to install. As a general rule, ensure that the latest (security) updates are installed on your operating system.
Database client software
For Oracle databases, you require both of the following:
  • Oracle Services for Microsoft Transaction Server (ORAMTS)
  • Oracle Data Provider for .NET (ODP.NET)
For maintenance, configuration and debugging purposes, RWS recommends that you also install the Oracle SQL Developer PL/SQL IDE (or SQL*Plus) and Oracle Net.
Environment variables
For Oracle databases where you have defined a Net Service Name for each database in a tnsnames.ora file, you must also have defined a TNS_ADMIN environment variable. Set it to the directory where tnsnames.ora resides.
Microsoft .NET Framework
You require a .NET Framework version. The one to use depends on your Windows Server operating system version:
Security
You need to be logged in as a user with sufficient security clearance. For example, to run a script that installs a database, you must be logged in as a user with rights to create that database.