I have two databases one normal Tridion and one for broker Database. I am using Tridion 5.3.

How does Tridion know which broker database to use? How do I put it in my configuration?

3 Answers 3


in cd_broker_conf.xml

you have section like following.

      <Database Type="sql">
      <Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
          <DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource">
          <Property Name="serverName" Value="db"/>
          <Property Name="portNumber" Value="1433"/>
          <Property Name="databaseName" Value="Tridion_broker"/>
          <Property Name="user" Value="uid"/>
          <Property Name="password" Value="pwd"/>

As Raj says, this is stored in the cd_broker_conf.xml file.

You will find this file in to following folder: C:\Program Files\Tridion\config (assuming that Tridion was installed in the default location)

NOTE: If you make any changes to this file, you will need to restart the Tridion Content Broker and Tridion Content Deployer Windows Services (or the Java processes), to get the changes to take effect.

You may also need to restart the Tridion Cache Channel Service and Tridion Dynamic Linking Services for good measure too.

  • 2
    You will also need to restart the Deployer service (if installed) as that is also using the Broker for storing published content. Sep 5, 2013 at 12:54
  • Indeed the linking service also used the Broker configuration ;) Sep 5, 2013 at 13:01
  • Thanks for all of your answers Raj,Miguel,Jonathan and Bart :)
    – neil
    Sep 6, 2013 at 3:15
  • Actually, Bart , I am planning on refreshing my dev/test tridion databases from live. I have two databases one tridion and one broker. So, I was wondering if I clean the broker database completely and recreate all tables and users for brokers, how would the broker tables then populate with values, I mean what would trigger that.
    – neil
    Sep 6, 2013 at 3:18
  • @neil if you want to clean the db, what is purpose of restoring it from production? Is publishing already working in your environment or you need to setup it?
    – Raj Kumar
    Sep 6, 2013 at 3:42

Just want to add that in case of a J2EE application the configuration in the cd_broker_conf.xml could be pointing to a JNDI instead having those values written in the configuration file. In that case you will have to go to the definition of the JNDI in the Application Server to find those values.

  • Yup thats right . It does point to jndi, I know the databases and passwords, I just need to know the above.
    – neil
    Sep 6, 2013 at 12:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.