Documentation Center

Database settings

You can configure the Content Manager database in the Database section of SDL Tridion Sites Content Manager configuration. All of These values are initially set during installation.

Procedure

  1. In the config\ subdirectory of %TRIDION_HOME%, open Tridion.ContentManager.config for editing.
  2. Navigate to the Database section.
  3. Configure the following settings:
    SettingValue
    Database advanced connection settings

    Set this setting if you want to specify any advanced connection settings for your SQL Server or Oracle database. Refer to your database product documentation about connection strings to learn which properties you can set and which values they can have.

    Write the connection string as a set of strings of the format Property=Value, separated by semicolons.

    SQL Server example:

    Application Name="My Application"; Max Pool Size=1024

    Oracle example:

    Max Pool Size=1024; Min Pool Size=2
    Database authentication method (MSSQL Only)Set this to the value Integrated to use Windows Integrated Security.
    Database login passwordThe password for the user specified under Database login username.
    Database login usernameThe user name login account for the Content Manager database.
    Database nameThe name of the database instance.
    Database server nameThe name of the database server. To refer to a specific port number, fill in SERVERNAME,PORT where SERVERNAME is the database server name and PORT is the port number of the instance. You can also use SERVERNAME\INSTANCENAME to refer to a specific instance.
    Database typeThe type of the database. This is a read-only value set by the Content Manager installer.
  4. Restart IIS and COM+ to ensure updated settings are used—for performance reasons, the processes that use the MMC Snap-in settings cache them in memory.