Verify a Reporting Services InstallationVerify a Reporting Services Installation

Reporting ServicesReporting Services 報表伺服器:原生或 SharePoint。report servers can be installed in one of two modes, Native or SharePoint. 確認安裝所應遵循的步驟會視報表伺服器模式而定。The steps you should follow for verifying the installation depend on the report server mode.

注意

SQL Server 2016 後即不再提供 Reporting Services 與 SharePoint 的整合。Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

確認 SharePoint 模式安裝Verify SharePoint Mode Installation

確認 Reporting Services 服務To verify the Reporting Services Service

  1. 從 SharePoint 管理中心,按一下 [系統設定] 群組中的 [管理伺服器上的服務]From SharePoint central administration, click Manage services on server in the System Settings group.

  2. 確認已安裝 [SQL Server Reporting Services 服務] ,且該服務處於 [執行中] 狀態。Verify the SQL Server Reporting Services Service is installed and in the Running state.

    如果您在清單中未看到 Reporting ServicesReporting Services 服務,請確認是否已安裝此服務。If you do not see the Reporting ServicesReporting Services service in the list, verify the service is installed. 如需詳細資訊,請參閱以 SharePoint 模式安裝第一部報表伺服器For more information, see Install the first Report Server in SharePoint mode.

確認服務應用程式To verify the Service Application

  1. 若要從管理中心確認您至少具有一個 Reporting ServicesReporting Services 服務應用程式,請按一下 [應用程式管理] 群組中的 [管理服務應用程式]To verify from Central Administration you have at least one Reporting ServicesReporting Services service application, click Manage Service Applications in the Application Management group.

  2. 確認 [SQL Server Reporting Services 服務應用程式] 類型的服務應用程式確實存在,而且有對應的應用程式 Proxy。Verify there is a service application of type SQL Server Reporting Services Service Application and a corresponding application proxy.

  3. 在服務應用程式名稱 附近 按一下,然後在 SharePoint 工具列中按一下 [屬性]Click near the name of the service application and then click Properties in the SharePoint toolbar. 如果您按一下服務應用程式的名稱,即會開啟服務應用程式的 [管理] 頁面,而不是屬性頁面。If you click the name of the service application it will open the Management pages of the service application, not the properties page.

  4. 確認 [Web 應用程式關聯] 設定為指向所需的 Web 應用程式。Verify the Web Application Association is configured to point to the desired web application.

確認網站集合功能To verify the Site collection Feature

  1. 在網站設定中,按一下 [網站集合管理] 群組中的 [網站集合功能]In site settings, click Site collection Features in the Site Collection Administration group.

  2. 確認已啟用 [報表伺服器整合功能]Verify the Report Server Integration Feature is active.

確認報表伺服器內容類型To Verify Reporting Server content types

  1. 若要確認或加入 Reporting ServicesReporting Services 報表伺服器內容類型,請參閱 將 Reporting Services 內容類型加入至 SharePoint 文件庫To verify or add Reporting ServicesReporting Services report server content types, see Add Reporting Services Content Types to a SharePoint Library.

確認您可以啟動報表產生器To verify you can launch Report Builder

  1. 從文件庫中,按一下 SharePoint 功能區中的 [文件]From a document library, click Documents in the SharePoint ribbon.

  2. 按一下 [新增文件] ,然後再按一下 [報表產生器報表]Click New Document and click Report Builder Report. 如果您看不到這個選項,請檢閱有關將報表伺服器內容類型加入文件庫的先前程序。If you do not see this option, review the previous procedure on adding the report server content types to a library.

建立基本報表Create a basic report

  1. 在 SharePoint 文件庫中,建立只包含一個文字方塊 (例如標題) 的基本 Reporting ServicesReporting Services 報表。In a SharePoint document library, create a basic Reporting ServicesReporting Services report that only contains a text box, for example a title. 此報表不包含任何資料來源或資料集。The report does not contain any data sources or datasets. 其目的是要確認您可以開啟報表產生器,而且基本報表將會進行預覽。The goal is to verify you can open Report Builder and a basic report will preview.

  2. 將報表儲存至文件庫,然後從文件庫中執行報表。Save the report to the document library and the run the report from the library. 如需使用報表產生器建立報表的詳細資訊,請參閱 啟動報表產生器For more information on creating reports with Report Builder, see Start Report Builder.

Reporting Services 範例Reporting Services samples

  1. 完成其中一個 Reporting Services 教學課程。Complete one of the Reporting Services tutorials. 如需詳細資訊,請參閱 Reporting Services 教學課程 (SSRS)For more information, see Reporting Services Tutorials (SSRS).

  2. 從 GitHub 下載 Adventure Works 範例資料庫和 Reporting ServicesReporting Services 範例報表。Download the Adventure works sample database and the Reporting ServicesReporting Services sample reports from GitHub. 如需詳細資訊,請參閱 AdventureWorks 範例資料庫For more information, see AdventureWorks sample databases.

驗證原生模式安裝Verify a Native Mode Installation

當您使用預設組態安裝原生模式報表伺服器時,安裝程式會安裝和部署該伺服器。When you install a Native mode report server using the default configuration, Setup installs and deploys the server. 您可以執行一些簡單的測試,來確認安裝程式是否部署報表伺服器。You can verify whether Setup deployed the report server by performing a few simple tests. 您必須是本機管理員才能執行這些步驟。You must be a local administrator to perform these steps. 若要讓其他使用者能夠執行測試,您必須為那些使用者設定報表伺服器存取權。To enable other users to perform testing, you must configure report server access for those users.

確認報表伺服器已安裝及執行To verify that the report server is installed and running

  1. 執行 Reporting ServicesReporting Services 組態工具,並連接到您剛安裝的報表伺服器執行個體。Run the Reporting ServicesReporting Services Configuration tool and connect to the report server instance you just installed. [Web 服務 URL] 頁面包含報表伺服器 Web 服務的連結。The Web Service URL page includes a link to the Report Server Web service. 請按一下此連結,確認您可以存取伺服器。Click the link to verify you can access the server. 如果報表伺服器資料庫並未設定,請在按一下連結之前先行設定。If the report server database is not configured, do that first before clicking the link.

  2. 開啟 [服務] 主控台應用程式,並確認報表伺服器服務正在執行中。Open the Services console applications and verify that the Report Server service is running. 若要檢視報表伺服器服務的狀態,請按一下 [開始] ,指向 [控制台] ,並按兩下 [系統管理工具] ,然後按兩下 [服務] 。To view the status of the Report Server service, click Start, point to Control Panel, double-click Administrative Tools, and then double-click Services. 當服務清單出現時,請捲動至 [報表伺服器 (MSSQLSERVER)] 。When the list of services appears, scroll to Report Server (MSSQLSERVER). 其狀態應該是 [已啟動]The status should be Started.

  3. 開啟瀏覽器,並在位址列輸入報表伺服器 URL。Open a browser and type the report server URL in the address bar. 位址是由您在安裝期間對報表伺服器指定的伺服器名稱和虛擬目錄名稱所組成。The address consists of the server name and the virtual directory name that you specified for the report server during setup. 報表伺服器虛擬目錄的預設名稱為 ReportServerBy default, the report server virtual directory is named ReportServer. 您可以使用下列 URL 來確認報表伺服器的安裝: https://<電腦名稱> /ReportServer<_執行個體名稱> 。You can use the following URL to verify report server installation: https://<computer name>/ReportServer*<_instance name>*. 如果您將報表伺服器安裝成具名執行個體,則需使用不同的 URL。The URL will be different if you installed the report server as a named instance. 如需 URL 格式的詳細資訊,請參閱設定報表伺服器 URL (SSRS 設定管理員)For more information about the URL format, see Configure Report Server URLs (SSRS Configuration Manager). 如果您是 Windows Vista 或 Windows Server 2008 的本機系統管理員,請參閱設定原生模式報表伺服器進行本機管理 (SSRS)If you are a local administrator on Windows Vista or Windows Server 2008, see Configure a Native Mode Report Server for Local Administration (SSRS).

  4. 執行報表來測試報表伺服器作業。Run reports to test report server operations. 在此步驟中,您可以根據教學課程建立範例報表。For this step, you can create a sample report from a tutorial. 如需詳細資訊,請參閱建立基本資料表報表 (SSRS 教學課程)For more information, see Create a Basic Table Report (SSRS Tutorial).

確認 入口網站web portal 已安裝且正在執行To verify that the 入口網站web portal is installed and running

  1. 開啟瀏覽器,並在位址列輸入入口網站 URL。Open a browser and type the Web Portal URL in the address bar. 此位址是由伺服器名稱和虛擬目錄名稱所組成,此目錄名稱是在安裝期間針對 入口網站web portal 所指定,或是在 Reporting Services 組態工具的 [入口網站 URL] 頁面中指定。The address consists of the server name and the virtual directory name that you specified for the 入口網站web portal during setup or in the Web Portal URL page in the Reporting Services Configuration tool. 依預設, 入口網站web portal 虛擬目錄為 ReportsBy default, the 入口網站web portal virtual directory is Reports. 您可以使用下列 URL 確認 入口網站web portal 的安裝:You can use the following URL to verify the 入口網站web portal installation:

    https://<電腦名稱> /Reports<_執行個體名稱> 。https://<computer name>/Reports*<_instance name>*.

  2. 使用 入口網站web portal 來建立新資料夾,或上傳檔案來測試定義是否傳回至報表伺服器資料庫。Use the 入口網站web portal to create a new folder or upload a file to test whether definitions are passed back to the report server database. 如果這些作業都成功,表示連接可運作。If these operations are successful, the connection is functional.

    如需詳細資訊,請參閱入口網站 (SSRS 原生模式)For more information, see Web Portal (SSRS Native Mode).

確認報表設計師已安裝及執行To verify that Report Designer is installed and running

  1. 開啟 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT),並根據報表伺服器專案類型來建立新的專案。Open SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT), and create a new project based on a Report Server project type. 如需使用 [報表伺服器專案精靈] 的詳細資訊,請參閱《SQL Server 線上叢書》中的 SQL Server 資料工具中的 Reporting Services (SSDT)For more information on using the Report Server Project Wizard, see Reporting Services in SQL Server Data Tools (SSDT) in SQL Server Books Online.

  2. 如果您已安裝報表範例,請開啟範例報表專案檔,並將報表發行至報表伺服器。If you installed report samples, open the sample report project files and publish the reports to a report server.

另請參閱See Also

疑難排解 Reporting Services 安裝 Troubleshoot a Reporting Services Installation
Reporting Services 錯誤的原因和解決方案Cause and Resolution of Reporting Services Errors