疑難排解 Reporting Services 安裝Troubleshoot a Reporting Services Installation

如果您因為安裝期間發生的錯誤而無法安裝 Reporting ServicesReporting Services ,請使用本主題的指示來處理最有可能造成安裝錯誤的狀況。If you cannot install Reporting ServicesReporting Services because of errors that occur during setup, use the instructions in this topic to address the conditions that are most likely to cause installation errors.

如需有關 SQL Server 2014SQL Server 2014問題的最新資訊,請參閱 Reporting Services SQL Server 2012 提示、秘訣和疑難排解For The latest information regarding issues with SQL Server 2014SQL Server 2014, see Reporting Services SQL Server 2012 Tips Tricks, and Troubleshooting

如需有關與 Reporting ServicesReporting Services 相關之其他錯誤和問題的詳細資訊,請參閱 疑難排解 SSRS 問題和錯誤For information about other errors and issues related to Reporting ServicesReporting Services see Troubleshoot SSRS issues and errors.

如果您碰到的問題在版本資訊中有描述,請檢閱 線上版本資訊Review the Online Release Notes in case the issue you encounter is described in the release notes.

本主題包含下列資訊:This topic contains the following information:

檢查安裝記錄檔Check Setup Logs

安裝錯誤會記錄在Program FILES\MICROSOFT SQL Server\110\Setup Bootstrap\Log資料夾的記錄檔中。Setup errors are recorded in log files in the Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log folder. 每當您執行安裝程式時,都會建立一個子資料夾,A subfolder is created each time you run Setup. 此子資料夾的名稱就是您執行安裝程式的時間和日期。The subfolder name is the time and date you ran Setup. 如需如何檢視安裝記錄檔的指示,請參閱 檢視與讀取 SQL Server 安裝記錄檔For instructions on how to view the Setup log files, see View and Read SQL Server Setup Log Files.

  • 記錄檔包含檔案的集合。The log files include a collection of files.

  • 開啟 *_summary.txt 檔,即可檢視產品、元件和執行個體的資訊。Open the *_summary.txt file to view product, component, and instance information.

  • 開啟 *_errorlog.txt 檔,即可檢視安裝期間所產生的錯誤資訊。Open the *_errorlog.txt file to view error information generated during Setup.

  • 開啟 *_RS_*_ComponentUpdateSetup.log,即可檢視 Reporting ServicesReporting Services 安裝程式資訊。Open the *_RS_*_ComponentUpdateSetup.log to view Reporting ServicesReporting Services setup information.

檢查必要條件Check Prerequisites

安裝程式會自動檢查必要條件。Setup checks prerequisites automatically. 但是,如果您正在排除安裝問題,知道安裝程式正在檢查哪些需求將會很有協助。However, if you are troubleshooting setup problems, it is helpful to know which requirements Setup is checking for.

  • 執行安裝程式的帳戶需求包括本機管理員群組的成員資格。Account requirements for running Setup include membership in the local Administrators group. 安裝程式必須具有加入檔案、登錄設定、建立本機安全性群組及設定權限的權限。Setup must have permission to add files, registry settings, create local security groups, and set permissions. 如果您要安裝預設組態,安裝程式必須具有在您進行安裝所在 [SQL Server]SQL Server 執行個體上建立報表伺服器資料庫的權限。If you are installing a default configuration, Setup must have permission to create a report server database on the [SQL Server]SQL Server instance on which you are installing.

  • 作業系統必須支援 HTTP.SYS 1.1。Operating System must support HTTP.SYS 1.1.

  • HTTP 服務必須已啟用且在執行中。HTTP service must be enabled and running.

  • 如果您也要安裝 [SQL Server]SQL Server Agent 服務,則分散式交易協調器 (DTC) 必須在執行中。Distributed Transaction Coordinator (DTC) must be running if you are also installing [SQL Server]SQL Server Agent service.

  • Authz.dll 必須存在於 System32 資料夾中。Authz.dll must be present in the System32 folder.

安裝程式不再檢查 Internet Information Services (IIS) 或 ASP.NETASP.NETSetup no longer checks for Internet Information Services (IIS) or ASP.NETASP.NET. Reporting ServicesReporting Services 需要 MDAC 2.0 與 MicrosoftMicrosoft .NET Framework.NET Framework 2.0 版;如果尚未安裝,則安裝程式會加以安裝。requires MDAC 2.0 and the MicrosoftMicrosoft .NET Framework.NET Framework version 2.0; Setup will install these if they are not already installed.

疑難排解 SharePoint 模式安裝的問題Troubleshoot Problems with SharePoint Mode installations

Reporting Services 組態管理員未啟動Reporting Services Configuration Manager Does not start

描述這個問題是由中SQL Server 2014SQL Server 2014的設計。Description: This issue is by design in SQL Server 2014SQL Server 2014. Reporting ServicesReporting Services 現在的架構為 SharePoint 服務架構。The Reporting ServicesReporting Services is now architected for the SharePoint service architecture. 在 SharePoint 模式中設定及管理 Reporting ServicesReporting Services 時,不再需要組態管理員。The Configuration Manager is no longer needed to configure and administer Reporting ServicesReporting Services in SharePoint mode.

因應措施: 您可以使用 SharePoint 管理中心,在 SharePoint 模式下設定報表伺服器。Workaround: Use SharePoint Central Administration to configure a report server in SharePoint mode. 如需詳細資訊,請參閱 管理 Reporting Services SharePoint 服務應用程式For more information, see Manage a Reporting Services SharePoint Service Application

在 SharePoint 模式中安裝 SQL Server 2012 SSRS 之後, 您在 SharePoint 管理中心內看不到 SQL Server Reporting Services 服務You do not see the SQL Server Reporting Services service in SharePoint Central Administration after installing SQL Server 2012 SSRS in SharePoint mode

描述SQL Server 2014SQL Server 2014如果成功安裝Reporting ServicesReporting Services Reporting ServicesReporting Services SQL Server 2014SQL Server 2014 sharepoint 模式的和適用于 sharepoint 2010 的增益集之後, 您在下列兩個功能表中看不到 [SQL Server Reporting Services], 表示服務具有Reporting ServicesReporting Services未註冊:Description: If after successfully installing SQL Server 2014SQL Server 2014 Reporting ServicesReporting Services in SharePoint mode and the SQL Server 2014SQL Server 2014 Reporting ServicesReporting Services Add-in for SharePoint 2010, you do not see "SQL Server Reporting Services" in the following two menus, then the Reporting ServicesReporting Services service has not been registered:

  • SharePoint 2010 管理中心-> 「應用程式管理」-> 「管理伺服器上的服務」頁面SharePoint 2010 Central Administration -> "Application Management" -> "Manage Services on Server" page

  • SharePoint 2010 管理中心-> "應用程式管理"-> [管理服務應用程式]-> [新增] 功能表SharePoint 2010 Central Administration -> "Application Management" -> "Manage Service Applications" ->"New" menu

因應措施: 若要註冊並啟動Reporting ServicesReporting Services SharePoint Services, 請完成下列步驟:Workaround: To register and start the Reporting ServicesReporting Services SharePoint Services, complete the following:

  1. 在執行 SharePoint 2010 管理中心的電腦上On the computer that runs SharePoint 2010 Central Administration

    1. 使用系統管理員權限來開啟 SharePoint 2010 管理命令介面。Open the SharePoint 2010 Management Shell with administrator privileges. 以滑鼠右鍵按一下圖示,然後按一下 [以系統管理員身分執行]。Right click the icon and click, "Run As Administrator". 在命令介面中執行下列三個指令程式:Run the following three cmdlets from the shell:

    2. Install-SPRSService  
      
    3. Install-SPRSServiceProxy  
      
    4. Get-SPServiceInstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance  
      
  2. 確認服務Reporting ServicesReporting Services在頁面上將狀態顯示為「已啟動」:SharePoint 2010 管理中心-> 「應用程式管理」-> 「管理伺服器上的服務Verify the Reporting ServicesReporting Services Service shows status as "Started" on the page: SharePoint 2010 Central Administration -> "Application Management" -> "Manage Services on Server"

Reporting Services PowerShell 指令程式無法使用,而且無法辨識命令Reporting Services PowerShell cmdlets are not available and commands are not recognized

描述當您嘗試執行Reporting ServicesReporting Services PowerShell Cmdlet 時, 您會看到類似下面的錯誤訊息:Description: When you try to run a Reporting ServicesReporting Services PowerShell cmdlet, you see an error message similar to the following:

  • 無法辨識 'Install-SPRSServiceInstall-SPRSService' 詞彙是否為 Cmdlet、函數、指令檔或可執行程式的名稱。The term 'Install-SPRSServiceInstall-SPRSService' is not recognized as the name of a cmdlet, function, script file, or operable program. 請檢查名稱的拼寫, 或如果已包含路徑, 請確認路徑正確, 然後再試一次。在第: 1 char:39 + Install-Install-sprsserviceinstall-sprsservice-Install-sprsserviceinstall-sprsservice < < < < + CategoryInfo:ObjectNotFound(安裝-Install-sprsserviceinstall-sprsservice-Install-sprsserviceinstall-sprsservice: String)[], CommandNotFoundExcepCheck the spelling of the name, or if a path was included, verify that the path is correct and try again.At line:1 char:39+ Install-SPRSServiceInstall-SPRSService <<<< + CategoryInfo : ObjectNotFound: (Install-SPRSServiceInstall-SPRSService:String) [], CommandNotFoundExcep

因應措施: 完成下列其中一項:Workaround: Complete one of the following:

  • 執行適用於 SharePoint 產品的 Reporting ServicesReporting Services 增益集。Run the Reporting ServicesReporting Services add-in for SharePoint products. rssharepoint.msirssharepoint.msi.

  • 從 SQL Server 安裝媒體安裝 Reporting ServicesReporting Services SharePoint 模式。Install Reporting ServicesReporting Services SharePoint mode from the SQL Server installation media.

注意: 如果當您完成其中一個解決方法時, SharePoint 2013 管理命令介面已開啟, 請關閉並重新開啟管理命令介面。Note: If the SharePoint 2013 Management Shell is open when you complete one of the workarounds, close and reopen the management shell.

如需詳細資訊,請參閱下列內容:For more information, see the following:

您看見一則錯誤訊息,指出 URL 未設定You see an error message indicating the URL is not configured

描述您會看到類似下面的錯誤訊息:Description: You see and error message similar to the following:

系統不支援這項 SQL Server Reporting Services (SSRS) 功能。This SQL Server Reporting Services (SSRS) functionality is not supported. 請使用管理中心來確認並修正下列一個或多個問題:•報表伺服器 URL 未設定。Use Central Administration to verify and fix one or more of the following issues:•A report server URL is not configured. 請使用 SSRS 整合頁面來設定它。•SSRS 服務應用程式 Proxy 未設定。Use the SSRS Integration page to set it.•The SSRS service application proxy is not configured. 請使用 SSRS 服務應用程式頁面來設定 Proxy。•SSRS 服務應用程式並未對應至此 Web 應用程式。Use the SSRS service application pages to configure the proxy.•The SSRS service application is not mapped to this web application. 請使用 SSRS 服務應用程式頁面,將 SSRS 服務應用程式 Proxy 關聯至此 Web 應用程式的應用程式 Proxy 群組。Use the SSRS service application pages to associate the SSRS service application proxy to the Application Proxy Group for this web application.

因應措施: 錯誤訊息包含三個修正此問題的建議步驟。Workaround: The error message contains three suggested steps to correct this issue. 「報表伺服器 URL 未設定」訊息中的第一個建議。The first suggestion in the message 'A report server URL is not configured..' 是與 SQL Server 2012SQL Server 2012之前的報表伺服器版本整合時相關。is relevant when integrating with report server version previous to SQL Server 2012SQL Server 2012. 先前報表伺服器版本的 SharePoint 設定是在 [一般應用程式設定] 頁面上,使用 [SQL Server Reporting Services (2008 和 2008 R2)] 來完成。SharePoint Configuration for the previous report server versions is completed on the General Application Settings page, using the SQL Server Reporting Services (2008 and 2008 R2)..

詳細資訊: 當您嘗試使用任何Reporting ServicesReporting Services需要Reporting ServicesReporting Services服務連線的功能時, 將會看到此錯誤訊息。More Information: You will see this error message when attempting to use any of the Reporting ServicesReporting Services functionality that requires a connection to the Reporting ServicesReporting Services service. 這包括:This includes:

  • 從 SharePoint 文件庫開啟 SQL Server 報表產生器。Opening SQL Server Report Builder from a SharePoint document library.

  • 管理訂閱。Manage Subscriptions.

  • 管理服務應用程式。Manage a service application.

在已安裝 SharePoint 但尚未進行設定的電腦上,安裝程式會失敗Setup fails on a computer with SharePoint installed but it is not configured

描述如果您選擇在已安裝 SharePoint 但未設定 SharePoint 的電腦上安裝 Reporting Services SharePoint 模式, 您會看到類似下列的訊息, 且安裝程式將會停止:Description: If you select to install Reporting Services SharePoint Mode on a computer that has SharePoint installed but SharePoint is not configured, you will see a message similar to the following and setup will stop:

SQL Server 安裝程式已停止運作SQL Server Setup has stopped working

因應措施: 設定 SharePoint, 然後執行 SQL Server 安裝。Workaround: Configure SharePoint and then run SQL Server Installation.

詳細資訊: 安裝Reporting ServicesReporting Services到現有的 sharepoint 安裝時, 安裝程式會嘗試安裝並Reporting ServicesReporting Services啟動 sharepoint 服務。More Information: When installing Reporting ServicesReporting Services into and existing SharePoint installation, setup attempts to install and start the Reporting ServicesReporting Services SharePoint service. 若尚未設定 SharePoint,服務安裝將會失敗並會導致安裝程式失敗。If SharePoint is not configured, the service installation fails, causing setup to fail.

SharePoint 管理中心頁面是空白的SharePoint Central Administration Page is blank

描述您可以順利安裝 SharePoint 2010, 而不會發生安裝錯誤。Description: You were able to successfully install SharePoint 2010, with no installation errors. 但當您瀏覽至管理中心時,只看到了空白頁面:However when you browse to Central Administration, you only see a blank page:

因應措施: 這個問題不是特有的Reporting ServicesReporting Services , 但與整體 SharePoint 安裝中的許可權設定有關。Workaround: This issue is not specific to Reporting ServicesReporting Services but is related to the configuration of permissions in your overall SharePoint installation. 下列是建議的清單:The following is a list of suggested:

嘗試建立新的報表產生器報表時看到錯誤訊息You see an error Message when you try to create a new Report Builder Report

描述當您嘗試在文件庫中建立報表產生器報表時, 您會看到類似下面的錯誤訊息:Description: You see an error message similar to the following when you attempt to create a Report Builder report inside a document library:

尚未支援此功能,因為 SQL Server Reporting Services 服務應用程式不存在,或是未於管理中心設定報表伺服器 URL。This functionality is not supported because a SQL Server Reporting Services service application does not exist or a report server URL has not been configured in Central Administration.

因應措施: 確認您有Reporting ServicesReporting Services服務應用程式, 且已正確設定。Workaround: Verify you have an Reporting ServicesReporting Services service application and it is correctly configured. 如需詳細資訊, 請參閱Install Reporting Services Sharepoint Mode For sharepoint 2010中的「建立 Reporting Services 服務應用程式」一節For more information see, the section 'Create a Reporting Services Service Application' in Install Reporting Services SharePoint Mode for SharePoint 2010

您會看到使用 PREPAREIMAGE 時不支援 RS_SHP 的錯誤訊息You see an error message that RS_SHP is not supported with PREPAREIMAGE

描述當您嘗試執行 PREPAREIMAGE Reporting ServicesReporting Services時, 您會看到類似下面的錯誤訊息:Description: When you try to run PREPAREIMAGE for Reporting ServicesReporting Services you see an error message similar to the following:

「執行 PREPAREIMAGE 動作時不支援指定的功能 'RS_SHP',因為此動作不支援 SysPrep。"The specified feature 'RS_SHP' is not supported when running the PREPAREIMAGE action, since it does not support SysPrep. 請移除與 SysPrep 不相容的功能,然後重新執行安裝程式。」Remove the features that are not compatible with SysPrep and run setup again."

因應措施: 沒有解決方法。Workaround: There is no work around. Reporting ServicesReporting Services 不支援 SYSPREP (PREPAREIMAGE)。does not support SYSPREP (PREPAREIMAGE). Reporting ServicesReporting Services 原生模式支援 SYSPREP。Native mode does support SYSPREP.

疑難排解原生模式安裝的問題Troubleshoot Problems with the Native Mode Installations

升級到 Windows Vista 或 Windows Server 2008 之後,看不到效能計數器Performance counters are not visible after upgrading to Windows Vista or Windows Server 2008

如果您在執行 Windows VistaWindows Vista 的電腦上,將作業系統升級為 Windows Server 2008Windows Server 2008Reporting ServicesReporting Services,在升級之後將不會設定 Reporting ServicesReporting Services 效能計數器。If you upgrade the operating system to Windows VistaWindows Vista or Windows Server 2008Windows Server 2008 on a computer that runs Reporting ServicesReporting Services, Reporting ServicesReporting Services performance counters will not be set after the upgrade.

若要重新恢復 Reporting Services 效能計數器To reinstate Reporting Services performance counters

  1. 刪除下列登錄機碼:Delete the following registry keys:

    • HKLM\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web ServiceHKLM\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web Service

    • HKLM\SYSTEM\CurrentControlSet\Services\MSRS 2011 Windows ServiceHKLM\SYSTEM\CurrentControlSet\Services\MSRS 2011 Windows Service

  2. 開啟命令視窗,然後在命令提示字元下輸入下列命令:Open a command window and type the following command at the prompt:

    • 執行< .net 2.0 Framework 目錄 > \InstallUtil.exe < 報表伺服器 Bin 目錄 > \ReportingServicesLibrary.dllrun < .NET 2.0 Framework directory >\InstallUtil.exe < Report Server Bin directory >\ReportingServicesLibrary.dll

      注意

      將< .net 2.0 Framework 目錄> 取代為 .NET Framework 2.0 檔案的實體路徑, 並以<報表伺服器 bin 檔案的實體路徑來取代報表伺服器 bin 目錄>。Replace <.NET 2.0 Framework directory> with the physical path of the .NET Framework 2.0 files and replace <Report Server Bin directory> with the physical path of the report server bin files.

  3. 重新啟動 Reporting ServicesReporting Services 服務。Restart the Reporting ServicesReporting Services service.

若要上述步驟是否有效,請開啟網頁瀏覽器,並導覽至報表管理員 URL 或報表伺服器 URL。To verify that the steps worked, open a Web browser and navigate to the Report Manager URL or the Report Server URL. 然後,開啟效能監視器來確認計數器是否有在運作。Then open Performance Monitor to verify that the counters are working.

若要使用登錄編輯程式重新加入效能登錄機碼To re-add the performance registry keys by using Registry Editor

  1. 開啟登錄編輯程式:Open the Registry Editor:

    1. 按一下 [開始] ,並按一下 [執行]Click Start, and click Run.

    2. 在 [執行] 對話方塊的 [開啟] 方塊中, regedit輸入。In the Run dialog box, in the Open box, type regedit.

  2. 在 [登錄編輯程式] 中,選取下列登錄機碼: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web Service\PerformanceIn Registry Editor, select the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web Service\Performance

  3. 以滑鼠右鍵按一下 [Performance] 節點,並指向 [新增],然後按一下 [多字串值]。Right-click the Performance node, point to New, and click Multi-String Value.

  4. 輸入 Counter Names,然後按 ENTER。Type Counter Names and then press ENTER.

  5. 重複上述步驟,在這個節點中加入 Counter Types 登錄機碼。Repeat to add the Counter Types registry key in this node.

  6. 瀏覽到以下的登錄機碼: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web Service\PerformanceNavigate to the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web Service\Performance

  7. 以滑鼠右鍵按一下 [Performance] 節點,並指向 [新增],然後按一下 [多字串值]。Right-click the Performance node, point to New, and click Multi-String Value.

  8. 輸入 Counter Names,然後按 ENTER。Type Counter Names and then press ENTER.

  9. 重複上述步驟,在這個節點中加入 Counter Types 登錄機碼。Repeat to add the Counter Types registry key in this node.

修復 64 位元執行個體或手動重新加入登錄機碼後,可以使用效能監視器設定您要監視的 Reporting ServicesReporting Services 效能物件。After you repair the 64-bit instance or re-add the registry keys manually, you can use Performance Monitor to configure the Reporting ServicesReporting Services performance objects that you want to monitor.

從 SQL Server 2005 升級後,ReportServerExternalURL 和 PassThroughCookies 組態屬性未設定ReportServerExternalURL and PassThroughCookies configuration properties are not configured after an upgrade from SQL Server 2005

當您從 SQL Server 2005SQL Server 2005 升級到 SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS),升級程序不會設定 ReportServerExternalURLPassThroughCookies 組態屬性。When you upgrade from SQL Server 2005SQL Server 2005 to SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS), the ReportServerExternalURL and PassThroughCookies configuration properties are not configured by the upgrade process. ReportServerExternalURL是選擇性屬性, 只有在您使用 SharePoint 2.0 Web 組件, 而且想要讓使用者能夠抓取報表並在新的瀏覽器視窗中開啟時, 才應該設定。ReportServerExternalURL is an optional property, and it should be set only if you are using SharePoint 2.0 Web Parts and you want users to be able to retrieve a report and open it in a new browser window. 如需的詳細ReportServerExternalURL資訊, 請參閱設定檔(SSRS Configuration Manager)中的 urlFor more information about ReportServerExternalURL, see URLs in Configuration Files (SSRS Configuration Manager). PassThroughCookies只有在使用自訂驗證方法時才需要。PassThroughCookies is required only when using Custom authentication method. 如需的詳細PassThroughCookies資訊, 請參閱設定報表管理員以傳遞自訂驗證 cookieFor more information about PassThroughCookies, see Configure Report Manager to Pass Custom Authentication Cookies.

注意

當您使用自訂驗證時,建議您移轉安裝,而不要執行升級。When you use Custom authentication, it is recommended that you migrate your installation rather than performing an upgrade. 如需移轉 Reporting ServicesReporting Services 的詳細資訊,請參閱移轉 Reporting Services 安裝 (原生模式)For more information about migrating Reporting ServicesReporting Services, see Migrate a Reporting Services Installation (Native Mode).

根據預設,這些屬性不存在 SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) 組態中。By default, these properties do not exist in the SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) configuration. 如果您在 SQL Server 2005SQL Server 2005 中設定了這些屬性,而且仍然需要這些屬性的功能,就必須在升級程序之後將這些屬性手動加入至 RSReportServer.config 檔案。If you configured these properties in SQL Server 2005SQL Server 2005 and you continue to require the functionality that they provide, you must manually add them to the RSReportServer.config file following the upgrade process. 如需詳細資訊,請參閱修改 Reporting Services 組態檔 (RSreportserver.config)For more information, see Modify a Reporting Services Configuration File (RSreportserver.config).

在執行 SQL Server 2012Reporting Services 的電腦上, SQL Server 2005 Reporting Services 的預設實例安裝失敗Installation fails for a default instance of SQL Server 2005 Reporting Services on a computer that runs SQL Server 2012Reporting Services

如果您嘗試Reporting ServicesReporting Services在已經執行實例的SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS)電腦SQL Server 2005SQL Server 2005上安裝的預設實例, Reporting ServicesReporting Services實例將無法安裝, SQL Server 2005SQL Server 2005並出現下列錯誤訊息:If you attempt to install a default instance of SQL Server 2005SQL Server 2005 Reporting ServicesReporting Services on a computer that already runs an instance of SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS), the SQL Server 2005SQL Server 2005 Reporting ServicesReporting Services instance will fail to install with the following error message:

「具有相同名稱的執行個體已安裝在這部電腦上。"An instance with the same name is already installed on this computer. 若要繼續 SQL Server 安裝程式,請提供唯一的執行個體名稱。」To proceed with SQL Server Setup, provide a unique instance name."

不論 SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) 執行個體是預設或具名執行個體,也不論電腦上是否已存在相同名稱的 SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) 執行個體,都會發生這個問題。This issue happens regardless of whether the SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) instance is a default or named instance, and regardless of whether a SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) instance with that name already exists on the computer.

若要解決這個問題,請使用下列其中一個選項:To work around this issue, you have one of the following options:

  • 如果您必須在SQL Server 2005SQL Server 2005電腦上以預設實例的形式執行Reporting ServicesReporting Services Reporting ServicesReporting Services SQL Server 2005SQL Server 2005 , 您必須在SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS)實例之前安裝實例。If you must run SQL Server 2005SQL Server 2005 Reporting ServicesReporting Services as the default instance on the computer, you must install the SQL Server 2005SQL Server 2005 Reporting ServicesReporting Services instance before the SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) instance.

  • Reporting ServicesReporting Services SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) SQL Server 2005SQL Server 2005如果實例不需要是預設實例, 您可以在安裝實例之後, 將實例安裝為已命名的實例。 Reporting ServicesReporting Services SQL Server 2005SQL Server 2005If the SQL Server 2005SQL Server 2005 Reporting ServicesReporting Services instance does not need to be a default instance, you can install the SQL Server 2005SQL Server 2005 Reporting ServicesReporting Services instance as a named instance after you install the SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) instance.

401-從 SQL Server 2005 升級至 SQL Server 2012 之後, 使用 Windows 驗證時發生未經授權的錯誤401-Unauthorized error when using Windows authentication after an upgrade from SQL Server 2005 to SQL Server 2012

如果您從 SQL Server 2005SQL Server 2005 Reporting ServicesReporting Services 升級到 SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS),而且對報表伺服器服務帳戶使用 NTLM 驗證及內建帳戶,當您在升級後存取報表伺服器或報表管理員時,可能會遇到 401 未經授權錯誤。If you upgrade from SQL Server 2005SQL Server 2005 Reporting ServicesReporting Services to SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS), and you use NTLM authentication with a built-in account for the Report Server service account, you might encounter a 401-Unauthorized error when you access the report server or Report Manager after the upgrade.

之所以發生這個錯誤,是因為 Windows 驗證的預設 SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) 組態中出現變更。This happens because of a change in the default SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) configuration for Windows authentication. 當報表伺服器服務帳戶是 Network Service 或 Local System 時,會設定交涉。Negotiate is configured when the Report Server service account is either Network Service or Local System. 如果報表伺服器服務帳戶不是上述其中一個內建帳戶時,則會設定 NTLM。NTLM is configured when the Report Server service account is not one of those built-in accounts. 若要在升級後修正這個問題,您可以編輯 RSReportServer.config 檔案,並將 AuthenticationType 設為 RSWindowsNTLMTo fix this issue after you upgrade, you can edit the RSReportServer.config file and configure the AuthenticationType to be RSWindowsNTLM. 如需詳細資訊,請參閱 設定報表伺服器上的 Windows 驗證For more information, see Configure Windows Authentication on the Report Server.

在具有64位實例的並存部署中, 卸載 SQL Server 2012 Reporting Services 的32位實例會中斷64位實例Uninstalling 32-bit instance of SQL Server 2012 Reporting Services in side-by-side deployment with a 64-bit instance breaks the 64-bit instance

當您在電腦上並存安裝 SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) 的 32 位元執行個體與 64 位元執行個體後,如果解除安裝 32 位元執行個體,就會移除四個 Reporting ServicesReporting Services 登錄機碼。When you install a 32-bit instance and a 64-bit instance of SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS) side-by-side on a computer, and you uninstall the 32-bit instance, four Reporting ServicesReporting Services registry keys are removed. 這會中斷 Reporting ServicesReporting Services的 64 位元執行個體。This breaks the 64-bit instance of Reporting ServicesReporting Services. 當您解除安裝 32 位元執行個體時,會移除的 Reporting ServicesReporting Services 登錄機碼如下:The Reporting ServicesReporting Services registry keys that are removed when you uninstall the 32-bit instance are:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web Service\Performance:Counter Names HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Windows Service\Performance:Counter Names HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web Service\Performance:Counter Types HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Windows Service\Performance:Counter TypesHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web Service\Performance:Counter Names HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Windows Service\Performance:Counter Names HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Web Service\Performance:Counter Types HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2011 Windows Service\Performance:Counter Types

若要修正這個問題,您可以修復 64 位元執行個體。To fix this issue, you can repair the 64-bit instance. 雖然建議您使用修復,不過您也可以使用登錄編輯程式以手動方式重新加入登錄機碼。Although it is recommended to use repair, you can re-add the registry keys manually by using Registry Editor.

警告

不當編輯登錄可能會造成系統嚴重受損。Incorrectly editing the registry can severely damage your system. 在變更登錄之前,應備份電腦上的所有重要資料。Before making changes to the registry, you should back up any valued data on the computer.

其他資源Additional Resources

下列為您可檢閱以協助您進行問題疑難排解的其他資源:The following are additional resources you can review to assist you with trouble shooting issues:

SharePoint 設定透過 Microsoft SQL Server Connect 提交意見反應和連絡人資訊(https://connect.microsoft.com/SQLServer/Feedback).SharePoint Settings Submit feedback and contact information through Microsoft SQL Server Connect (https://connect.microsoft.com/SQLServer/Feedback).