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

时间:2021-07-19 03:15:09

原创地址:http://www.cnblogs.com/jfzhu/p/4012097.html

转载请注明出处

前面的文章《Step by step SQL Server 2012的安装 》中,介绍过如何安装SQL Server 2012,其中的Database Engine Services和Reporting Services - Native安装在了同一台服务器上,但是为了提高性能,我们可以将Database Engine与Reporting Service分别安装在不同的服务器上。

我们的演示环境里两台服务器Eindhoven-SQL2是SQL Server,Eindhoven-SQL3是SSRS Server。SQL Server上面只需要安装Database Engine Services和Management Tools,SSRS服务器上只需要安装Reporting Services和SQL Server Data Tools(开发报表使用)。

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

安装Report Server前面的步骤和《Step by step SQL Server 2012的安装 》一样,从Feature Selection开始有所不同:

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

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

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

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

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

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

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

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

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

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

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

到这里安装完毕,如果Database Engine和SSRS安装在同一台服务器上,系统会自动配置reporting services,但是像我们这样分布在不同的服务器上安装,我们需要手动配置reporting services。

打开Reporting Services Configuration Manager

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

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

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

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

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

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

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

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

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

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

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

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

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

完成配置后,SQL Server上会创建两个数据库ReportServer和ReportServerTempDB。

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

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

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

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

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

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

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

总结:

SQL Server Database Engine和SSRS Server可以分开在不同的服务器上安装,SQL Server上面只需要安装Database Engine Services和Management Tools,SSRS服务器上只需要安装Reporting Services和SQL Server Data Tools(开发报表使用)。SSRS装好后需要配置,配置好后会在SQL Server中创建ReportServer和ReportServerTempDB两个数据库。

参见《NIB - How to: Install a Local Report Server and Remote Report Server Database》