安装 SQL Server Reporting ServicesInstall SQL Server Reporting Services

适用对象:APPLIES TO: SQL Server Reporting Services(2017 和更高版本) Power BI 报表服务器 SQL Server Reporting Services(2017 和更高版本) Power BI 报表服务器

SQL Server Reporting Services 安装涉及到用于存储报表项、呈现报表以及处理订阅和其他报表服务的服务器组件。SQL Server Reporting Services installation involves server components for storing report items, rendering reports, and processing of subscription and other report services.

通过 Microsoft 下载中心下载 SQL Server 2019 Reporting ServicesDownload SQL Server 2019 Reporting Services from the Microsoft Download Center.

通过 Microsoft 下载中心下载 SQL Server 2017 Reporting ServicesDownload SQL Server 2017 Reporting Services from the Microsoft Download Center.

备注

要查找 Power BI 报表服务器?Looking for Power BI Report Server? 请参阅安装 Power BI 报表服务器See Install Power BI Report Server.

从 Reporting Services 的 SQL Server 2016 或更早版本进行升级或迁移?Upgrading or migrating from a SQL Server 2016 or earlier version of Reporting Services? 请参阅升级和迁移 Reporting ServicesSee Upgrade and Migrate Reporting Services.

开始之前Before you begin

安装 Reporting Services 前,请查看安装 SQL Server 的硬件和软件要求Before you install Reporting Services, review the Hardware and software requirements for installing SQL Server.

安装报表服务器Install your report server

安装报表服务器非常简单。Installing a report server is straightforward. 只需几个步骤即可安装文件。There are only a few steps to install the files.

备注

安装时无需有可用的 SQL Server 数据库引擎服务器。You do not need a SQL Server Database Engine server available at the time of install. 安装后需要有可用的该服务器才可配置 Reporting Services。You will need one to configure Reporting Services after install.

  1. 查找 SQLServerReportingServices.exe 的位置并启动安装程序。Find the location of SQLServerReportingServices.exe and launch the installer.

  2. 选择“安装 Reporting Services” 。Select Install Reporting Services.

  3. 选择要安装的版本,然后选择“下一步” 。Choose an edition to install and then select Next.

    对于免费版本,可从下拉列表中选择评估版或开发人员版。For a free edition, choose either Evaluation or Developer from the drop down.

    评估版或开发人员版

    或者,输入产品密钥。Otherwise, enter a product key. 查找 SQL Server Reporting Services 的产品密钥Find the product key for SQL Server Reporting Services.

  4. 阅读并同意许可条款,然后选择“下一步” 。Read and agree to the license terms and conditions and then select Next.

  5. 需要有可用的数据库引擎才可存储报表服务器数据库。You need to have a Database Engine available to store the report server database. 选择“下一步”,仅安装报表服务器 。Select Next to install the report server only.

  6. 指定报表服务器的安装位置。Specify the install location for the report server. 选择“安装”以继续操作 。Select Install to continue.

    备注

    默认路径为 C:\Program Files\Microsoft SQL Server Reporting Services。The default path is C:\Program Files\Microsoft SQL Server Reporting Services.

  7. 安装成功后,选择“配置报表服务器”,启动报表服务器配置管理器。After a successful setup, select Configure Report Server to launch the Report Server Configuration Manager.

配置报表服务器Configure your report server

在安装程序中选择“配置报表服务器”后,可看到“报表服务器配置管理器” 。After you select Configure Report Server in the setup, you will be presented with Report Server Configuration Manager. 有关详细信息,请参阅报表服务器配置管理器For more information, see Report Server Configuration Manager.

需要创建报表服务器数据库,以便完成 Reporting Services 的初始配置。You need to create a report server database to complete the initial configuration of Reporting Services. 完成此步骤需要 SQL Server 数据库服务器。A SQL Server Database server is required to complete this step.

在不同服务器上创建数据库Creating a database on a different server

如果要在其他计算机上的数据库服务器中创建报表服务器数据库,需要将报表服务器的服务帐户更改为数据库服务器上已识别的凭据。If you are creating the report server database on a database server on a different machine, you need to change the service account for the report server to a credential that is recognized on the database server.

默认情况下,报表服务器使用虚拟服务帐户。By default, the report server uses the virtual service account. 如果尝试在不同服务器上创建数据库,则可能会在“应用连接权限”步骤中收到以下错误消息。If you try to create a database on a different server, you may receive the following error on the Applying connection rights step.

System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group '(null)' not found. Check the name again.

要解决此错误,可将服务帐户更改为网络服务或域帐户。To work around the error, you can change the service account to either Network Service or a domain account. 将服务帐户更改为网络服务会在报表服务器计算机帐户的上下文中应用权限。Changing the service account to Network Service applies rights in the context of the machine account for the report server.

有关详细信息,请参阅配置报表服务器服务帐户For more information, see Configure the report server service account.

Windows 服务Windows Service

Windows 服务是在安装过程中创建的。A windows service is created as part of the installation. 它显示为 SQL Server Reporting Services 。It is displayed as SQL Server Reporting Services. 服务名称为 SQLServerReportingServices 。The service name is SQLServerReportingServices.

默认 URL 预留Default URL reservations

URL 预留由前缀、主机名、端口和虚拟目录组成:URL reservations are composed of a prefix, host name, port, and virtual directory:

组成部分Part 说明Description
前缀Prefix 默认的前缀为 HTTP。The default prefix is HTTP. 如果你以前安装过传输层安全性 (TLS)(旧称为“安全套接字层 (SSL)”)证书,安装程序会尝试创建使用 HTTP 前缀的 URL 预留。If you previously installed a Transport Layer Security (TLS), previously known as Secure Sockets Layer (SSL), certificate, Setup tries to create URL reservations that use the HTTPS prefix.
主机名Host name 默认主机名为强通配符 (+)。The default host name is a strong wildcard (+). 它指定对于解析为计算机的任何主机名,报表服务器均会接受指定端口上的任何 HTTP 请求,包括 https://<computername>/reportserverhttps://localhost/reportserverhttps://<IPAddress>/reportserver.It specifies that the report server accepts any HTTP request on the designated port for any host name that resolves to the computer, including https://<computername>/reportserver, https://localhost/reportserver, or https://<IPAddress>/reportserver.
端口Port 默认端口为 80。The default port is 80. 如果使用端口 80 以外的其他任何端口,则在浏览器窗口中打开 Web 门户时,必须将该端口显式添加至 URL 中。If you use any port other than port 80, you have to explicitly add it to the URL when you open web portal in a browser window.
虚拟目录Virtual directory 默认情况下,虚拟目录创建时的格式为 ReportServer(适用于报表服务器 Web 服务)和 Reports(适用于 Web 门户)。By default, virtual directories are created in the format of ReportServer for the Report Server Web service and Reports for the web portal. 对于报表服务器 Web 服务,默认的虚拟目录为 reportserverFor the Report Server Web service, the default virtual directory is reportserver. 对于 Web 门户,默认的虚拟目录为 reports 。For the web portal, the default virtual directory is reports.

完整的 URL 字符串示例如下所示:An example of the complete URL string might be as follows:

  • https://+:80/reportserver 用于访问报表服务器。https://+:80/reportserver, provides access to the report server.

  • https://+:80/reports,用于访问 Web 门户。https://+:80/reports, provides access to the web portal.

防火墙Firewall

从远程计算机访问报表服务器时,如果存在防火墙,需要确保配置了任意防火墙规则。If you are accessing the report server from a remote machine, you want to make sure you have configured any firewall rules if there is a firewall present.

需要打开为 Web 服务 URL 和 Web 门户 URL 配置的 TCP 端口。You need to open up the TCP port that you have configured for your Web Service URL and Web Portal URL. 默认情况下,在 TCP 端口 80 上进行配置。By default, these are configured on TCP port 80.

其他配置Additional configuration

有关如何安装 SQL Server Reporting Services 本机模式的信息,请参阅安装 Reporting Services 本机模式报表服务器For information on how to install SQL Server Reporting Services native mode, see Install Reporting Services native mode report server.

有关如何在 SharePoint 集成模式下安装 SQL Server 2016 Reporting Services(及更早版本)的信息,请参阅在 SharePoint 模式下安装第一个报表服务器For information on how to install SQL Server 2016 Reporting Services (and earlier) in SharePoint integration mode, see Install the first Report Server in SharePoint mode.

后续步骤Next steps

安装报表服务器后,开始创建报表并将其部署到报表服务器。With your report server installed, begin to create reports and deploy those to your report server. 有关如何开始使用报表生成器的信息,请参阅安装报表生成器For information on how to start with Report Builder, see Install Report Builder.

要使用 SQL Server Data Tools 创建报表,请下载 SQL Server Data ToolsTo create reports using SQL Server Data Tools, download SQL Server Data Tools.

更多疑问?More questions? 请访问 Reporting Services 论坛Try asking the Reporting Services forum