Step by step Install a Local Report server and Remote Report Server Database

Original address: http://www.cnblogs.com/jfzhu/p/4012097.html

Reprint please indicate the source

The previous article, "Step by Step SQL Server 2012 installation," describes how to install SQL Server 2012, where database Engine Services and reporting services-native are installed in The same server, but to improve performance, we can install the database engine and the reporting service on separate servers.

Our demo environment in which two servers eindhoven-sql2 is SQL SERVER,EINDHOVEN-SQL3 is SSRS server. SQL Server only needs to be installed on database Engine services and Management Tools,ssrs server only need to install Reporting Services and SQL Server Data Tools (Development Report usage).

The steps prior to installing report Server are the same as for the installation of step by step SQL Server 2012, starting with feature selection:

Installation is complete here, if database engine and SSRS are installed on the same server, the system will automatically configure Reporting Services, but as we are distributing on different servers, we need to manually configure Reporting Services.

Open reporting Services Configuration Manager

When the configuration is complete, two databases ReportServer and reportservertempdb are created on SQL Server.

Summarize:

SQL Server and SSRS server can be installed separately on different servers, and SQL Server only needs to install Database engine services and management Tools, Only Reporting Services and SQL Server Data Tools (Development Report usage) need to be installed on the SSRS server. When SSRS is installed, it needs to be configured and configured to create ReportServer and reportservertempdb two databases in SQL Server.

Refer to the Nib-how to:install a Local report server and the Remote server Database

Step by step Install a Local Report server and Remote Report Server Database