安裝 SQL Server Reporting Services (2017 和更新版本)Install SQL Server Reporting Services (2017 and later)

適用於:APPLIES TO: 是SQL Server Reporting Services (2017 和更新版本)SQL Server Reporting Services (2017 and later) 否Power BI 報表伺服器Power BI Report Server是SQL Server Reporting Services (2017 和更新版本)SQL Server Reporting Services (2017 and later) 否Power BI 報表伺服器Power BI Report Server

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 2017 Reporting Services。To download SQL Server 2017 Reporting Services, go to the Microsoft Download Center.

注意

尋找 Power BI 報表伺服器嗎?Looking for Power BI Report Server? 請參閱安裝 Power BI 報表伺服器See Install Power BI Report Server.

開始之前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.

    安裝 Reporting Services

  3. 選擇安裝版本,然後選取 [下一步] 。Choose an edition to install and then select Next.

    選擇版本

    在免費版本中,從下拉式清單中選擇 Evaluation 或 Developer。For a free edition, choose either Evaluation or Developer from the drop down.

    Evaluation 或 Developer 版本

    否則,請輸入產品金鑰。Otherwise, enter a product key. 尋找 SQL Server 2017 Reporting Services 的產品金鑰.Find the product key for SQL Server 2017 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. 成功安裝之後,選取 [設定報表伺服器] 啟動 Reporting Services 設定管理員。After a successful setup, select Configure Report Server to launch the Reporting Services Configuration Manager.

    設定報表伺服器

設定報表伺服器Configuration 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 Database 伺服器需要完成此步驟。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 ServicesIt is displayed as SQL Server Reporting Services. 服務名稱是 SQLServerReportingServicesThe service name is SQLServerReportingServices.

預設 URL 保留項目Default URL reservations

URL 保留項目是由前置詞、主機名稱、通訊埠和虛擬目錄所組成:URL reservations are composed of a prefix, host name, port, and virtual directory:

部分Part DescriptionDescription
PrefixPrefix 預設前置詞是 HTTP。The default prefix is HTTP. 如果您之前安裝了安全通訊端層 (SSL) 憑證,安裝程式會嘗試建立使用 HTTPS 前置詞的 URL 保留項目。If you previously installed a 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 以外的任何連接埠,當您在瀏覽器視窗中開啟入口網站時,就必須明確將此連接埠新增至 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 根據預設,系統會建立虛擬目錄,報表伺服器 Web 服務使用 ReportServer 格式,入口網站使用 Reports 格式。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. 入口網站的預設虛擬目錄為 reportsFor 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,提供入口網站的存取權。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 和入口網站 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