Database connection strings for configuring servers

Last updated Tuesday, January 3, 2017 in Sitecore Experience Platform for Administrator, Developer

In the Sitecore Experience Platform (XP), when you configure servers to perform different roles in a scalable environment, you must configure several database connection strings for each server type.

To configure the connection strings for a Sitecore server instance, edit the ConnectionStrings.config file located in the Website\App_Config folder.

When you configure a Sitecore server, enable or disable the following connection strings:

Database

Connection String

CD server

CM server

Processing server

Reporting Service server

SQL Server

core

Enable

Enable

Enable

Enable

master

Disable

Enable

Enable

Enable

web

Enable

Enable

Disable

Enable

reporting

Disable

Enable

Enable

Enable

reporting.secondary (optional)

NA

NA

Enable

Enable

MongoDB

analytics

Enable

Enable

Enable

Enable

tracking.live

Enable

Enable

Enable

Enable

tracking.history

Disable

Disable

Enable

Enable

tracking.contact

Enable

Enable

Enable

Disable

Notes:

  • Content delivery servers do not require all the connection strings to be active.

    For example, there are some security benefits in removing the reporting connection string. Either remove these connection strings completely or add comment tags to hide them.

  • To perform historical processing by rebuilding the reporting database, you must add and enable an additional SQL Server connection string: reporting.secondary.