Sql-Server-2008-R2

升級 SQL Server 2012 時出現問題

  • February 4, 2014

當我嘗試將 SQL Server 2008 R2 升級到 SQL Server 2012 時,除了以下問題外,一切都很順利

在此處輸入圖像描述

我如何解決它?是否需要再次解除安裝 SQL Server 2012?

編輯

Feature:                       Reporting Services - Native
 Status:                        Failed: see logs for details
 Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
 Next Step:                     The upgrade process for SQL Server failed. Use the following information to resolve the error, and then repair your installation by using this command line: setup /action=repair /instancename=MSSQLSERVER
 Component name:                SQL Server Database Engine Services Instance Features
 Component error code:          0x84BB0001
 Error description:             Service 'SQLSERVERAGENT' stop request failed.
 Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0x2E920AA9%400xD3BEBD98%401211%401&EvtType=0x2E920AA9%400xD3BEBD98%401211%401

 Feature:                       Database Engine Services
 Status:                        Failed: see logs for details
 Reason for failure:            An error occurred during the setup process of the feature.
 Next Step:                     The upgrade process for SQL Server failed. Use the following information to resolve the error, and then repair your installation by using this command line: setup /action=repair /instancename=MSSQLSERVER
 Component name:                SQL Server Database Engine Services Instance Features
 Component error code:          0x84BB0001
 Error description:             Service 'SQLSERVERAGENT' stop request failed.
 Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0x2E920AA9%400xD3BEBD98%401211%401&EvtType=0x2E920AA9%400xD3BEBD98%401211%401

 Feature:                       Full-Text and Semantic Extractions for Search
 Status:                        Failed: see logs for details
 Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
 Next Step:                     The upgrade process for SQL Server failed. Use the following information to resolve the error, and then repair your installation by using this command line: setup /action=repair /instancename=MSSQLSERVER
 Component name:                SQL Server Database Engine Services Instance Features
 Component error code:          0x84BB0001
 Error description:             Service 'SQLSERVERAGENT' stop request failed.
 Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0x2E920AA9%400xD3BEBD98%401211%401&EvtType=0x2E920AA9%400xD3BEBD98%401211%401

 Feature:                       SQL Server Replication
 Status:                        Failed: see logs for details
 Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
 Next Step:                     The upgrade process for SQL Server failed. Use the following information to resolve the error, and then repair your installation by using this command line: setup /action=repair /instancename=MSSQLSERVER
 Component name:                SQL Server Database Engine Services Instance Features
 Component error code:          0x84BB0001
 Error description:             Service 'SQLSERVERAGENT' stop request failed.
 Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0x2E920AA9%400xD3BEBD98%401211%401&EvtType=0x2E920AA9%400xD3BEBD98%401211%401

編輯:修復時出錯

   SQL Server Setup has encountered the following error:

The specified value 'Repair' is invalid. To run in unattended mode, you must specify a valid ACTION. The valid values for ACTION are: '
None
RemovePatch
Uninstall
Install
Upgrade
Patch
Repair
LandingPage
ClusterReport
RunRules
PrepareFailoverCluster
CompleteFailoverCluster
InstallFailoverCluster
RemoveNode
AddNode
EditionUpgrade
Bootstrap
ComponentUpdate
Help
RebuildDatabase
RunDiscovery
PrepareImage
CompleteImage
ConfigureImage'

我用過的命令

D:/myfolder/setup.exe /q /ACTION=修復 /INSTANCENAME=MSSQLSERVER

維修後

在此處輸入圖像描述

我會嘗試手動停止它(從 services.msc 停止 SQL Server 代理)然後修復。

您的數據庫引擎服務升級失敗。在修復導致它首先失敗的問題後,您需要通過執行 setup /action=repair /instancename=MSSQLSERVER 來修復它。

引用自:https://dba.stackexchange.com/questions/58177