設定原生模式報表伺服器進行本機管理 (SSRS)Configure a Native Mode Report Server for Local Administration (SSRS)

如果您想要在本機管理報表伺服器執行個體,則在下列其中一個作業系統上部署 Reporting ServicesReporting Services 報表伺服器需要其他組態步驟。Deploying a Reporting ServicesReporting Services report server on one of the following operating systems requires more configuration steps if you want to administer the report server instance locally. 本主題說明如何設定報表伺服器以進行本機管理。This topic explains how to configure the report server for local administration. 如果您尚未安裝或設定報表伺服器,請參閱從安裝精靈 (安裝程式) 安裝 SQL Server管理 Reporting Services 原生模式報表伺服器If you have not yet installed or configured the report server, see Install SQL Server from the Installation Wizard (Setup) and Manage a Reporting Services Native Mode Report Server.

適用於:Applies to: Reporting ServicesReporting Services 原生模式適用於:Applies to: Reporting ServicesReporting Services Native mode
  • Windows Server 2012 R2Windows Server 2012 R2

  • Windows 8.1Windows 8.1

  • Windows 8Windows 8

  • Windows Server 2012Windows Server 2012

  • Windows Server 2008 R2Windows Server 2008 R2

  • Windows 7Windows 7

  • Windows Server 2008Windows Server 2008

由於標示的作業系統會限制權限,所以屬於本機管理員群組的成員會執行大部分的應用程式,就像使用標準使用者帳戶一樣。Because the noted operating systems limit permissions, members of the local Administrators group run most applications as if they are using the Standard User account.

雖然這個作法會提升系統的整體安全性,但是也會妨礙您使用 Reporting Services 為本機管理員建立之預先定義的內建角色指派。While this practice improves the overall security of your system, it prevents you from using the predefined, built-in role assignments that Reporting Services creates for local administrators.

組態變更概觀Overview of configuration changes

下列組態變更會設定伺服器,好讓您可以使用標準使用者權限來管理報表伺服器內容和作業:The following configuration changes configure the server so that you can use standard user permissions to manage report server content and operations:

  • Reporting ServicesReporting Services URL 加入至信任的網站。Add Reporting ServicesReporting Services URLs to trusted sites. 根據預設,在列出的作業系統上執行的 Internet Explorer 會在 [受保護模式] 下執行,此功能會封鎖瀏覽器要求,使其無法到達相同電腦上執行的高層級處理序。By default, Internet Explorer running on the listed operating systems runs in Protected Mode, a feature that blocks browser requests from reaching high-level processes that run on the same computer. 您可以為報表伺服器應用程式停用受保護模式,只要將這些應用程式加入為信任的網站即可。You can disable protected mode for the report server applications by adding them as Trusted Sites.

  • 建立授與您 (亦即報表伺服器管理員) 有權管理內容和作業的角色指派,而不需要使用 Internet Explorer 上的 [以系統管理員身分執行] 功能。Create role assignments that grant you, the report server administrator, permission to manage content and operations without having to use the Run as administrator feature on Internet Explorer. 為 Windows 使用者帳戶建立角色指派,就可以使用內容管理員和系統管理員權限取得報表伺服器的存取權 (透過可取代 Reporting Services 建立之預先定義的內建角色指派的明確角色指派)。By creating role assignments for your Windows user account, you gain access to a report server with Content Manager and System Administrator permissions through explicit role assignments that replace the predefined, built-in role assignments that Reporting Services creates.

設定本機報表伺服器和入口網站的管理To configure local Report Server and web portal administration

如果您瀏覽至本機報表伺服器而且看到類似於以下的錯誤,請完成本章節的組態步驟:Complete the configuration steps in this section if you are browsing to a local report server and you see errors similar to the following:

  • 使用者 'Domain\[user name]' 沒有必要權限。User 'Domain\[user name]' does not have required permissions. 請確認已授與足夠的權限,而且滿足 Windows 使用者帳戶控制 (UAC) 的限制。Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

瀏覽器中受信任的網站設定Trusted Site settings in the browser

  1. 使用 [以系統管理員身分執行] 權限開啟瀏覽器視窗。Open a browser window with Run as administrator permissions. 從 [開始] 功能表,以滑鼠右鍵按一下 [Internet Explorer] ,然後選取 [以系統管理員身分執行] 。From the Start menu, right-click Internet Explorer, and select Run as administrator.

  2. 若出現提示,請選取 [是] 以繼續。Select Yes when prompted to continue.

  3. 在 URL 網址中,輸入入口網站 URL。In the URL address, enter the web portal URL. 如需指示,請參閱報表伺服器的入口網站 (SSRS 原生模式)For instructions, see The web portal of a report server (SSRS Native Mode).

  4. 按一下 [工具]Click Tools.

  5. 按一下 [網際網路選項]Click Internet Options.

  6. 按一下 [安全性]Click Security.

  7. 按一下 [信任的網站]Click Trusted Sites.

  8. 按一下 [網站]Click Sites.

  9. 加入 https://<your-server-name>Add https://<your-server-name>.

  10. 如果您並未針對預設網站使用 HTTPS,請清除 [此區域內的所有網站需要伺服器驗證 (https:)] 核取方塊。Clear the check box Require server certification (https:) for all sites in this zone if you are not using HTTPS for the default site.

  11. 按一下 [加入]Click Add.

  12. 選取 [確定] 。Select OK.

入口網站資料夾設定Web portal folder settings

  1. 在入口網站中,於首頁上按一下 [管理資料夾] 。In the web portal, on the Home page, click Manage folder.

  2. 在 [管理] 資料夾頁面中,按一下 [安全性] ,然後選取 [新增群組或使用者] 。In the Manage folder page, click Security and then select Add group or user.

  3. 在 [新增角色指派] 頁面的 [群組或使用者] 欄位中,使用以下格式輸入您的 Windows 使用者帳戶:<domain>\<user>In the New Role Assignment page, in the Group or user field, type your Windows user account in this format: <domain>\<user>.

  4. 選取 [內容管理員]Select Content Manager.

  5. 選取 [確定] 。Select OK.

入口網站網站設定Web portal site settings

  1. 以系統管理權限開啟瀏覽器,並瀏覽至入口網站 https://<server name>/reportsOpen your browser with administrative privileges and browse to web portal, https://<server name>/reports.

  2. 選取首頁頂端列上的齒輪圖示,然後從下拉式功能表中選取 [網站設定] 。Select the gear icon on the top row the Home page and then Site Settings from the dropdown menu.

    齒輪圖示.

    提示

    注意: 如果您沒看到 [網站設定] 選項,請關閉並使用系統管理權限重新開啟瀏覽器,然後瀏覽至入口網站。Note: If you do not see the Site Settings option, close and reopen your browser and browse to web portal with administrative privileges.

  3. 在 [網站設定] 頁面上,選取 [安全性] ,然後選取 [新增群組或使用者] 。On the Site settings page, Select Security and then select Add group or user.

  4. 在 [群組或使用者名稱] 欄位中,使用以下格式輸入您的 Windows 使用者帳戶: <domain>\<user>In the Group or user name field, type your Windows user account in this format: <domain>\<user>.

  5. 選取 [系統管理員]Select System Administrator.

  6. 選取 [確定] 。Select OK.

  7. 關閉入口網站。Close web portal.

  8. 在不使用 [以系統管理員身分執行] 的情況下,於 Internet Explorer 中重新開啟入口網站。Re-open the web portal in Internet Explorer, without using Run as administrator.

設定 SQL Server Management Studio (SSMS) 來進行本機報表伺服器管理To configure SQL Server Management Studio (SSMS) for local report server administration

根據預設,您無法存取 SQL Server Management StudioSQL Server Management Studio 中所提供的所有報表伺服器屬性,除非您使用系統管理權限啟動 Management StudioManagement StudioBy default, you cannot access all of the report server properties available in SQL Server Management StudioSQL Server Management Studio unless you start Management StudioManagement Studio with administrative privileges.

若要設定 Reporting ServicesReporting Services 角色屬性和角色指派,好讓您不必每次都使用更高權限啟動 Management StudioManagement StudioTo configure Reporting ServicesReporting Services role properties and role assignments so you do not need to start Management StudioManagement Studio with elevated permissions each time:

  • 在 [開始] 功能表中,以滑鼠右鍵按一下 [Microsoft SQL Server Management StudioManagement Studio] ,然後按一下 [以系統管理員身分執行] 。From the Start menu, right-click Microsoft SQL Server Management StudioManagement Studio, and then click Run as administrator.

  • 連接到本機 Reporting ServicesReporting Services 伺服器。Connect to your local Reporting ServicesReporting Services server.

  • [安全性] 節點中,按一下 [系統角色]In the Security node, click System Roles.

  • 以滑鼠右鍵按一下 [系統管理員] ,然後按一下 [屬性]Right-click System Administrator and then click Properties.

  • [系統角色屬性] 頁面中,選取 [檢視報表伺服器屬性]In the System Role Properties page, select View report server properties. 選取您想要與系統管理員角色成員產生關聯的任何其他屬性。Select any other properties you want associated with members of the system administrators role.

  • 按一下 [確定] 。Click OK.

  • 關閉 Management StudioManagement StudioClose Management StudioManagement Studio

  • 若要將使用者加入「系統管理員」系統角色,請參閱本文稍早的入口網站網站設定一節。To add a user to the system role "system administrator", see the Web portal Site Settings section earlier in this article.

現在當您開啟 Management StudioManagement Studio 而且未明確選取 [以系統管理員身分執行] 時,還是可以存取報表伺服器屬性。Now when you open Management StudioManagement Studio and do not explicitly select Run as administrator you have access to the report server properties.

設定 SQL Server Data Tools (SSDT) 來發行至本機報表伺服器To configure SQL Server Data Tools (SSDT) to publish to a local report server

如果您已經在本主題的第一個章節所列的其中一個作業系統上安裝 SQL Server Data ToolsSQL Server Data Tools ,而且您希望 SSDT 與本機原生模式報表伺服器互動,您將會遇到權限錯誤,除非您以更高權限開啟 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) 或設定報表服務角色。If you installed SQL Server Data ToolsSQL Server Data Tools on one of the operating systems listed in the first section of this topic, and you want SSDT to interact with a local Native mode report server, you will experiences permission errors unless you open SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) with elevated permissions or configure reporting services roles. 例如,如果您沒有足夠的權限,您將會遇到類似以下的問題:For example, if you do not have sufficient permissions, you experience issues similar to the following:

  • 當您嘗試將報表項目部署到本機報表伺服器時,您會在 [錯誤清單] 視窗中看到類似下列的錯誤訊息:When you attempt to deploy report items to the local report server, you see an error message similar to the following in the Error List window:

    • 授與使用者 'Domain\<使用者名稱>' 的權限不足,無法執行此作業。The permissions granted to user 'Domain\<user name>' are insufficient for performing this operation.

若要在每次開啟 SSDT 時都以更高權限執行:To run with elevated permissions each time you open SSDT:

  1. 在 [開始] 功能表中,選取 [Microsoft SQL Server] ,然後以滑鼠右鍵按一下 [SQL Server Data Tools] 。From the start menu, select Microsoft SQL Server and then right-click SQL Server Data Tools. 按一下 [以系統管理員身分執行]Click Run as administrator

  2. 若出現提示,請選取 [是] 以繼續。Select Yes when prompted to continue.

您現在應該能夠將報表和其他項目部署到本機報表伺服器。You should now be able to deploy reports and other items to a local report server.

若要設定 Reporting ServicesReporting Services 角色指派,好讓您不必每次都使用更高權限啟動 SSDT:To configure Reporting ServicesReporting Services role assignments so you do not need to start SSDT with elevated permissions each time:

其他資訊Additional information

Reporting ServicesReporting Services 管理相關的額外且常見的組態步驟如下:在 Windows 防火牆中開啟通訊埠 80,以允許存取報表伺服器電腦。An additional and common configuration step related to Reporting ServicesReporting Services administration is to open port 80 in Windows Firewall to allow access to the report server computer. 如需指示,請參閱 Configure a Firewall for Report Server AccessFor instructions, see Configure a Firewall for Report Server Access.

另請參閱See also

管理 Reporting Services 原生模式報表伺服器Manage a Reporting Services Native Mode Report Server