Manage a Reporting Services SharePoint Service ApplicationManage a Reporting Services SharePoint Service Application

Reporting ServicesReporting Services 服務應用程式是從 SharePoint 管理中心進行管理。Service Applications are managed from SharePoint Central Administration. [管理] 和 [屬性] 頁面可讓您更新服務應用程式的組態以及常見的管理工作。The Management and Properties pages allow you to update the configuration of the service application as well as common administration tasks.

本主題涵蓋下列資訊:This topic covers the following information:

開啟服務應用程式屬性頁面To Open Service Application Properties Page

若要開啟 Reporting ServicesReporting Services 服務應用程式的屬性頁面,請完成下列步驟:To open the properties page for a Reporting ServicesReporting Services service application, complete the following:

  1. 在 [管理中心] 的 [應用程式管理] 群組中,按一下 [管理服務應用程式]In Central Administration, in the Application Management group, click Manage service applications.

  2. 在您的服務應用程式名稱附近按一下,或按一下 [類型] 資料行選取整個資料列,然後按一下 SharePoint 功能區中的 [屬性]Click near the name of your service application or on the type column, which will select the entire row, and then click Properties in the SharePoint ribbon.

如需服務應用程式屬性的詳細資訊,請參閱 步驟 3:建立 Reporting Services 服務應用程式For more information on service application properties, see Step 3: Create a Reporting Services Service Application.

開啟服務應用程式管理頁面To Open Service Application Management Pages

若要開啟 Reporting ServicesReporting Services 服務應用程式的管理頁面,請完成下列步驟:To open the management pages for a Reporting ServicesReporting Services service application, complete the following:

  1. 在 [管理中心] 的 [應用程式管理] 群組中,按一下 [管理服務應用程式]In Central Administration, in the Application Management group, click Manage service applications.

  2. 按一下服務應用程式的名稱, [管理 Reporting Services 應用程式] 頁面將會開啟。Click the name of your service application and the Manage Reporting Services Application page will open.

  3. 您也可以在名稱附近按一下,或按一下服務應用程式的 [類型] 資料行選取整個資料列,然後按一下 SharePoint 功能區中的 [管理]Alternatively, you could click near the name or on the type column for your service application, which will select the entire row, and then click Manage in the SharePoint ribbon.

系統設定頁面System Settings Page

系統設定頁面可讓您設定服務應用程式的行為和使用者體驗,包括各種逾時。The systems settings page allows you to configure the behavior and user experience of your service application including various timeouts.

報表設定Report Settings

設定Setting 註解Comments
外部影像逾時External Images Timeout 預設值為 600 秒。Default is 600 seconds.
快照集壓縮Snapshot Compression 預設值是 SQLDefault is SQL
系統報表逾時System Report Timeout 預設值是 1800 秒。Default is 1800 seconds.

指定報表伺服器上的報表處理是否在經過特定秒數之後逾時。Specify whether report processing times out on the report server after a certain number of seconds. 此值會套用至報表伺服器上的報表處理。This value applies to report processing on a report server. 它不會影響提供報表資料的資料庫伺服器上的資料處理。It does not affect data processing on the database server that provides the data for your report. 報表處理計時器時鐘在選取報表時會開始,而當報表開啟時就會結束。The report processing timer clock begins when the report is selected and ends when the report opens. 您所指定的值應該足以完成資料處理和報表處理。The value that you specify must be sufficient to complete both data processing and report processing.
系統快照集限制System Snapshot Limit 預設值為 -1,表示沒有限制。Default is -1, which is no limit.

設定整個網站要保留之報表記錄副本數目的預設值。Set a site-wide default value for the number of copies of report history to retain. 預設值會提供初始設定,以建立每個報表可儲存的快照集數目。The default value provides an initial setting that establishes the number of snapshots that can be stored for each report. 您可以在特定報表的屬性頁中指定不同的限制。You can specify different limits in property pages for specific reports.
預存參數存留期Stored Parameters Lifetime 預設值是 180Default is 180
預存參數臨界值Stored Parameters Threshold 預設值為 1500 天。Default is 1500 days.

工作階段設定Session Settings

設定Setting 註解Comments
工作階段逾時Session Timeout 預設值為 600 秒。Default is 600 seconds.
使用工作階段 CookieUse Session Cookies 預設值是 TRUE。Default is TRUE.
EDLX 報表逾時EDLX Report Timeout 預設值是 1800 秒。Default is 1800 seconds.

用於記錄的系統設定System Settings for Logging

設定Setting 註解Comments
啟用執行記錄Enable Execution Logging 預設值是 TRUE。Default is TRUE.

指定報表伺服器是否產生追蹤記錄以及這些記錄的保存天數。specify whether the report server generates trace logs and the number of days the log is kept. 的指令碼 。. 記錄會儲存在報表伺服器電腦的下列資料夾中:\Microsoft SQL Server\MSSQL.n\ReportServer\Log。The logs are stored on the report server computer in the \Microsoft SQL Server\MSSQL.n\ReportServer\Log folder. 每次服務重新啟動時,就會啟動新的記錄。A new log file is started each time the service is restarted. 如需有關記錄檔的詳細資訊,請參閱< Report Server Service Trace LogFor more information about log files, see Report Server Service Trace Log
執行記錄保留天數Execution Log Days Kept 預設值是 60 天。Default is 60 days.

Reporting ServicesReporting Services 全都支援 SharePoint ULS 記錄。all supports SharePoint ULS logging. 如需詳細資訊,請參閱 開啟 SharePoint 追蹤記錄的 Reporting Services 事件 (ULS)For more information, see Turn on Reporting Services events for the SharePoint trace log (ULS)

安全性設定Security Settings

設定Setting 註解Comments
啟用整合式安全性Enable Integrated Security 預設值是 TRUE。Default is TRUE.

指定是否可以使用要求報表之使用者的 Windows 安全性 Token 來建立報表資料來源的連接。Specifies whether a connection to a report data source can be made using the Windows security token of the user who requested the report.
啟用載入報表定義Enable Load Report Definition 預設值是 TRUE。Default is TRUE..
啟用遠端錯誤Enable Remote Errors 預設值是 FALSEDefault is FALSE
啟用測試連接詳細錯誤Enable Test Connection Detailed Errors 預設值是 TRUE。Default is TRUE.

用戶端設定Client Settings

設定Setting 註解Comments
啟用報表產生器下載Enable Report Builder Download 預設值是 TRUE。Default is TRUE.

指定用戶端是否能夠看到下載報表產生器應用程式的按鈕。Specifies whether clients are able to see the button for downloading the report builder application.
報表產生器啟動 URLReport Builder Launch URL 當報表伺服器不使用預設的報表產生器 URL 時,指定自訂 URL。Specify a custom URL when the report server does not use the default Report Builder URL. 這個設定是選擇性的。This setting is optional. 如果您沒有指定值,將會使用預設 URL,這樣會啟動報表產生器。If you do not specify a value, the default URL will be used, which launches Report Builder. 若要啟動報表產生器 3.0 當作 Click-Once 應用程式,請輸入下列值: http://<電腦名稱>/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application。To launch Report Builder 3.0 as a Click-Once application, enter the following value: http://<computername>/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application.
啟用用戶端列印Enable Client Printing 預設值是 TRUE。The Default is TRUE.

指定使用者是否可以下載提供列印選項的用戶端控制項。Specifies whether users can download the client side control, which provides printing options.
編輯工作階段逾時Edit Session Timeout 預設值是 7200 秒。Default is 7200 seconds.
編輯工作階段快取限制Edit Session Cache Limit 預設值為 5。Default is 5.

管理作業Manage Jobs

您可以檢視和刪除執行中的作業,例如報表訂閱及資料驅動訂閱所建立的作業。You can view and delete the running jobs, for example jobs that are created by report subscriptions and data-driven subscriptions. 此頁面並非用來管理訂閱,而是管理訂閱所觸發的作業。The page is not used to manage subscriptions, but rather jobs that are triggered by a subscription. 例如,排程為每小時執行一次的訂閱將會每小時產生作業,該作業會出現在 [管理作業] 頁面上。For example a subscription that is scheduled to run once an hour will generate a job once an hour that appears on the Manage Jobs page.

管理執行中的作業manage running jobs

金鑰管理Key Management

下表摘要說明 [金鑰管理] 頁面The following table summarizes the Kay Management pages


定期變更 Reporting Services 加密金鑰是安全性最佳作法。Periodically changing the Reporting Services encryption key is a security best practice. 建議您在進行 Reporting Services 的主要版本升級之後,立即變更金鑰。A recommended time to change the key is immediately following a major version upgrade of Reporting Services. 在升級之後變更金鑰可將升級循環以外,由變更 Reporting Services 加密金鑰所造成的其他服務中斷減至最少。Changing the key after an upgrade minimizes additional service interruption caused by changing the Reporting Services encryption key outside of the upgrade cycle.

[頁面]Page [描述]Description
備份加密金鑰Backup Encryptions Key 1) 在 [密碼:] 與 [確認密碼:] 方塊中鍵入密碼,然後按一下 [匯出]。1) Type a password in to the Password: and Confirm Password: boxes and click Export. 如果您輸入的密碼不符合網域原則的複雜性需求,則會顯示警告。You will see a warning if the password you typed is does not meet the complexity requirements of the domain policy.

2) 系統會提示您提供儲存金鑰檔的檔案位置。2) You will be prompted for a file location of where to save the key file. 您應考慮將金鑰檔儲存到與執行 Reporting ServicesReporting ServicesYou should consider storing the key file on a separate computer from the one that is running Reporting ServicesReporting Services. 預設檔案名稱與服務應用程式的名稱相同。The default file name is the same name as the service application.
還原加密金鑰Restore Encryption Key 1) 在 [檔案位置] 方塊中鍵入或瀏覽至金鑰檔。1) Type or browse to the key file in the File Location box

2) 在 [密碼] 方塊中,鍵入要用來備份加密檔案的密碼。2) In the Password box, type the password that was used to back up the encryption file.

3) 按一下 [確定]。3) Click OK
變更加密金鑰Change Encryption Key 這項作業將建立新的金鑰,並且重新加密已加密的內容。This operation will create a new key and re-encrypt your encrypted content. 如果您擁有許多內容,這項作業可能需要數小時才能完成。If you have a lot of content, this operation make take several hour.

變更加密金鑰作業完成時,建議您製作新金鑰的備份。When the change encryption key operation is complete, it is recommended you make a backup of your new key.
刪除加密的內容Deleted Encrypted Content 刪除的內容無法復原。Deleted content cannot be recovered.

** 重要事項 ** 刪除和重新建立對稱金鑰的動作無法反轉或恢復。** Important ** The action of deleting and recreating the symmetric key cannot be reversed or undone. 刪除或重新建立金鑰可能會對您目前的安裝造成重大的影響。Deleting or recreating the key can have important ramifications on your current installation. 如果您刪除金鑰,將會一併刪除對稱金鑰所加密的任何現有資料。If you delete the key, any existing data encrypted by the symmetric key will also deleted. 刪除的資料包括外部報表資料來源的連接字串、預存連接字串和一些訂閱資訊。Deleted data includes connection strings to external report data sources, stored connection strings, and some subscription information.

執行帳戶Execution Account

使用此頁面,即可設定自動處理所使用的帳戶。Use this page to configure an account to use for unattended processing. 當其他認證來源無法使用的特殊情況下,請使用此帳戶:This account is used under special circumstances when other sources of credentials are not available:

  • 當報表伺服器連接到不需要認證的資料來源時。When the report server connects to a data source that does not require credentials. 可能不需要認證的資料來源範例包括 XML 文件和某些用戶端資料庫應用程式。Examples of data sources that might not require credentials include XML documents and some client-side database applications.

  • 當報表伺服器連接到另一個伺服器,以擷取報表中所參考的外部影像檔或其他資源時。When the report server connects to another server to retrieve external image files or other resources that are referenced in a report.

設定這個帳戶是選擇性的,但若未設定此帳戶,當您使用外部影像及連接某些資料來源時,將會受到限制。Setting this account is optional, but not setting it limits your use of external images and connections to some data sources. 擷取外部影像檔時,報表伺服器會檢查是否可以建立匿名連接。When retrieving external image files, the report server checks to see if an anonymous connection can be made. 如果連接有密碼保護,報表伺服器便會使用自動報表處理帳戶連接到遠端伺服器。If the connection is password protected, the report server uses the unattended report processing account to connect to the remote server. 擷取報表的資料時,報表伺服器會模擬目前使用者、提示使用者提供認證、使用預存認證,或如果資料來源連接指定認證類型為 [無] 時,則會使用自動處理帳戶。When retrieving data for a report, the report server either impersonates the current user, prompts the user to provide credentials, uses stored credentials, or uses the unattended processing account if the data source connection specifies None as the credential type. 報表伺服器不允許系統在連接到其他電腦時,委派或模擬其服務帳戶認證,因此如果沒有其他認證可以使用,報表伺服器就必須使用自動處理帳戶。The report server does not allow its service account credentials to be delegated or impersonated when connecting to other computers, so it must use the unattended processing account if no other credentials are available.

您所指定的帳戶應該與用於執行服務帳戶的帳戶不同。The account you specify should be different from the one used to run the service account. 如果您在向外延展部署中執行報表伺服器,您必須在每一部報表伺服器上使用相同的方式設定此帳戶。If you are running the report server in a scale-out deployment, you must configure this account the same way on each report server.

您可以使用任何 Windows 使用者帳戶。You can use any Windows user account. 為求最佳效果,請選擇擁有讀取權限及網路登入權限的帳戶,以連接到其他電腦。For best results, choose an account that has read permissions and network logon permissions to support connections to other computers. 此帳戶必須擁有您想在報表中使用之任何外部影像或資料檔案的讀取權限。It must have read permissions on any external image or data file that you want to use in a report. 除非所有的報表資料來源和外部影像全都儲存在報表伺服器電腦上,否則請勿指定本機帳戶。Do not specify a local account unless all report data sources and external images are stored on the report server computer. 這種帳戶只適用於自動報表處理。Use the account only for unattended report processing.

PowerShell 相關內容PowerShell related content

以下是一個 PowerShell 命令範例,會傳回具有 UEAccount 屬性的 Reporting ServicesReporting Services 服務應用程式清單:The following is an example PowerShell command to return the list of Reporting ServicesReporting Services service applications with the UEAccount property:

Get-SPRSServiceApplication | Select typename, name, service, ueaccountname  

如需詳細資訊,請參閱 Reporting Services SharePoint 模式適用的 PowerShell CmdletFor more information, see PowerShell cmdlets for Reporting Services SharePoint Mode.


指定執行帳戶Specify an execution account
選取此項目來指定帳戶。Select to specify an account.

輸入 Windows 網域使用者帳戶。Enter a Windows domain user account. 請使用此格式:<網域\<使用者帳戶>。Use this format: <domain>\<user account>.

輸入密碼。Type the password.

確認密碼Confirm password
重新輸入密碼。Retype the password.

電子郵件設定E-mail Settings

使用此頁面,即可指定會啟用從報表伺服器傳遞報表伺服器電子郵件的 Simple Mail Transport Protocol (SMTP) 設定。Use this page to specify Simple Mail Transport Protocol (SMTP) settings that enable report server e-mail delivery from the report server. 您可以使用報表伺服器電子郵件傳遞延伸模組,透過電子郵件訂閱來散發報表或報表處理通知。You can use the Report Server E-Mail delivery extension to distribute reports or report processing notifications through e-mail subscriptions. 報表伺服器電子郵件傳遞延伸模組,需要使用 [從:] 欄位中的 SMTP 伺服器和電子郵件地址。The Report Server E-Mail delivery extension requires an SMTP server and an e-mail address to use in the From: field.


使用 SMTP 伺服器Use SMTP Server
指定報表伺服器電子郵件是透過 SMTP 伺服器來傳送。Specifies that report server e-mail is routed through an SMTP server.

傳出 SMTP 伺服器Outbound SMTP Server
指定要使用的 SMTP 伺服器或閘道。Specify the SMTP server or gateway to use. 您可以在網路上使用本機伺服器或 SMTP 伺服器。You can use a local server or an SMTP server on your network.

來源位址From Address
指定用於所產生電子郵件之 [從:] 欄位中的電子郵件地址。Specifies the e-mail address to use in the From: field of a generated e-mail. 您必須指定有權從 SMTP 伺服器傳送郵件的使用者帳戶。You must specify a user account that has permission to send mail from the SMTP server.

提供訂閱和警示Provision Subscriptions and Alerts

使用此頁面驗證 SQL Server Agent 是否正在執行,並且提供存取權讓報表服務能夠使用 SQL Server Agent。Use this page to verify if SQL Server Agent is running and to provision access for reporting services to use SQL Server Agent. SQL Server Agent 為 Reporting ServicesReporting Services 訂閱、排程和資料警示所需。SQL Server Agent is required for Reporting ServicesReporting Services subscriptions, schedules, and data alerts. SSRS 服務應用程式的佈建訂閱及警示Provision Subscriptions and Alerts for SSRS Service Applications

Proxy 關聯Proxy association

您建立 Reporting Services 服務應用程式時,會選取要產生關聯並且藉由 Reporting Services 服務應用程式提供存取權限的 Web 應用程式。When you created the Reporting Services service application you selected the web application to associate and provision permissions for access by the Reporting Services service application. 如果您選擇不產生關聯或想要變更關聯,可以使用下列步驟:If you chose to not associate or you want to change the association, you can use the following steps.

  1. 在 [SharePoint 管理中心] 的 [應用程式管理] 中,按一下 [設定服務應用程式關聯]In SharePoint Central Administration, in the Application Management, click Configure Service Application Associations.

  2. 在 [服務應用程式關聯] 頁面上,將檢視切換至 [服務應用程式]On the Service application Associations page, change the view to Service Applications.

  3. 尋找並按一下新的 Reporting ServicesReporting Services 服務應用程式的名稱。Find and click the name of your new Reporting ServicesReporting Services Service application. 您也可以按一下應用程式 Proxy 群組名稱 default ,將 Proxy 加入至預設群組,而不要完成下列步驟。You could also click the application proxy group name default to add the proxy to default group rather than completing the following steps.

  4. [編輯下列連線群組] 選取方塊中選取 [自訂]Select Custom in the selection box Edit the following group of connections.

  5. 核取您的 Proxy 的方塊,然後按一下 [確定]Check the box for your proxy and click Ok.