Content Manager database settings

Settings for the Content Manager database are located in the Content Manager XML configuration file, Tridion.ContentManager.config, which you can find on the Content Manager server in the config\ subfolder of %TRIDION_HOME%.

Database type

DescriptionThe type of the database server.
XPath/configuration/configSections/section/@type (if /configuration/configSections/section/@name has the value database)
Default if unspecified(None)

Server name

DescriptionThe 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.
XPath/configuration/database/@server
Default if unspecified(None)

Name

DescriptionThe name of the database instance.
XPath/configuration/database/@name
Default if unspecified(None)

User name

DescriptionThe user name used to sign in to the Content Manager database.
XPath/configuration/database/@username
Default if unspecified(None)

Password

DescriptionThe password used to sign in to the Content Manager database.
XPath/configuration/database/@password
Default if unspecified(None)

Authentication settings (Microsoft SQL Server databases only)

DescriptionSet to Integrated if you want to use Windows Integrated Security
XPath/configuration/database/@authenticationMethod
Default if unspecifiedNormal

Advanced connection settings

Description

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

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
Specifically, you can set the timeout for attempting to establish a connection to a database with this property-value pair:
Connect Timeout=SECONDS

where SECONDS is the number of seconds for the timeout period.

XPath/configuration/database/@advancedSettings
Default if unspecified(None)