設定原生模式報表伺服器進行本機管理 (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 2014(安裝)管理 Reporting Services 原生模式報表伺服器.If you have not yet installed or configured the report server, see Install SQL Server 2014 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 Report Manager 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, click All Programs, right-click Internet Explorer, and select Run as administrator.

  2. 按一下 [允許] 繼續進行。Click Allow to continue.

  3. 在 URL 網址中,輸入報表管理員 URL。In the URL address, enter the Report Manager URL. 如需指示,請參閱《[SQL Server]SQL Server 線上叢書》中的報表管理員 (SSRS 原生模式)For instructions, see Report Manager (SSRS Native Mode) in [SQL Server]SQL Server Books Online.

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

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

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

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

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

  9. 加入 http://<your-server-name>Add http://<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. 按一下 [確定] 。Click OK.

報表管理員資料夾設定Report Manager Folder Settings

  1. 在報表管理員的首頁上,按一下 [資料夾設定]In Report Manager, on the Home page, click Folder Settings.

  2. 在 [資料夾設定] 頁面中,按一下 [安全性]In the Folder Settings page, click Security.

  3. 按一下 [新增角色指派]Click New Role Assignment.

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

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

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

報表管理員網站設定Report Manager Site Settings

  1. 以系統管理權限開啟瀏覽器,並瀏覽至報表管理員 http://<server name>/reportsOpen your browser with administrative privileges and browse to report manager, http://<server name>/reports.

  2. 按一下首頁上方角落的 [站台設定]Click Site Settings in the upper corner of the Home page.

    提示

    注意: 如果您看不見站台設定選項,請關閉並重新開啟瀏覽器並瀏覽至報表管理員,以系統管理權限。Note: If you do not see the Site Settings option, close and reopen your browser and browse to report manager with administrative privileges.

  3. 按一下 [安全性]Click security.

  4. 按一下 [新增角色指派]Click New Role Assignment.

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

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

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

  8. 關閉報表管理員。Close Report Manager.

  9. 在 Internet Explorer 中重新開啟報表管理員,而不使用 [以系統管理員身分執行]Re-open Report Manager 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:

  • 在 [開始] 功能表中,依序按一下 [所有程式] 與 [SQL Server 2014] 、以滑鼠右鍵按一下 [Management StudioManagement Studio] ,然後按一下 [以系統管理員身分執行] 。From the Start menu, click All Programs, click SQL Server 2014, right-click 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 Report Manager Site Settings section earlier in this topic.

現在當您開啟 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 BI (SSDT) 來發行至本機報表伺服器To Configure SQL Server Data Tools BI (SSDT) to Publish to a Local Report Server

如果您已經在本主題的第一個章節所列的其中一個作業系統上安裝 SQL Server Data Tools - Business Intelligence for Visual Studio 2012SQL Server Data Tools - Business Intelligence for Visual Studio 2012 ,而且您希望 SSDT 與本機原生模式報表伺服器互動,您將會遇到權限錯誤,除非您以更高權限開啟 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) 或設定報表服務角色。If you installed SQL Server Data Tools - Business Intelligence for Visual Studio 2012SQL Server Data Tools - Business Intelligence for Visual Studio 2012 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. 從 [開始] 畫面中,輸入sql server然後按一下滑鼠右鍵SQL Server Data Tools for Visual StudioFrom the start screen, type sql server and then right-click SQL Server Data Tools for Visual Studio. 按一下 [以系統管理員身分執行]Click Run as administrator

    或者,在舊版作業系統上:Or, on older operating systems:

    在 [開始] 功能表中,依序按一下 [所有程式] 與 [SQL Server 2014] 、以滑鼠右鍵按一下 [SQL Server Data Tools] ,然後按一下 [以系統管理員身分執行] 。From the Start menu, click All Programs, click SQL Server 2014, right-click SQL Server Data Tools, and then click Run as administrator.

  2. 按一下 [ 繼續]。Click Continue.

  3. 按一下 [執行程式]Click Run Program.

您現在應該能夠將報表和其他項目部署到本機報表伺服器。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