You can configure a Sitecore reporting database (SQL Server) server to run on a separate SQL Server instance, or together on the same server with other Sitecore applications.
Creating a separate server for the reporting database gives you more control over performance and scalability.
As the reporting database only requires SQL Server, there is no need to install a Sitecore instance when you create a reporting database server.
To configure a Microsoft SQL Server instance as a dedicated reporting server:
- Install SQL Server 2008 R2 SP1 or later.
- Configure SQL Server according to the system requirements and Sitecore CMS installation instructions.
- If you have already configured separate content management and processing servers, open the
ConnectionStrings.configfile and modify the connection strings to point to your reporting database server.
Test your connections to ensure that your SQL Server instance is configured and running correctly. Configure connection strings according to the Sitecore CMS installation instructions.
You can only scale a SQL Server reporting database server vertically by adding more resources to a single server.