Database connection strings for configuring servers

Current version: 8.2

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.

Do you have some feedback for us?

If you have suggestions for improving this article,