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
- In the config\ subdirectory of %TRIDION_HOME%, open Tridion.ContentManager.config for editing.
- Navigate to the Database section.
- Configure the following settings:
Setting Value 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=1024Oracle example:
Max Pool Size=1024; Min Pool Size=2Database authentication method (MSSQL Only) Set this to the value Integrated to use Windows Integrated Security. Database login password The password for the user specified under Database login username. Database login username The user name login account for the Content Manager database. Database name The name of the database instance. Database server name The 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 type The type of the database. This is a read-only value set by the Content Manager installer. - 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.