2

When I tried to upgrade SQL Server 2008 R2 to SQL Server 2012 everything went well except below issue

enter image description here

How do I fix it? Do I need to uninstall SQL Server 2012 again?

EDIT

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

Edit: Error while reparing it

    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'

command I have used

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

After Repair

enter image description here

9
  • Instead of screenshot, better to post the exact error message !
    – Kin Shah
    Commented Feb 3, 2014 at 23:22
  • Check your error logs (which should be linked in the screen). Your logs will be located under C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log.
    – Mike Fal
    Commented Feb 3, 2014 at 23:23
  • The information you posted is from the summary. You're going to have to dig in to the details for the exact error text.
    – Mike Fal
    Commented Feb 4, 2014 at 0:04
  • Are you able to stop SQL Server Agent from the services.msc? I'd try to stop it manually and then run the upgrade.
    – Nienor
    Commented Feb 4, 2014 at 9:39
  • My upgrade is already finished. Do you mean that I have to stop SQL Server agent and then my upgrade wizard again? Commented Feb 4, 2014 at 9:43

1 Answer 1

3

I'd try to stop it manually (stop SQL Server Agent from the services.msc) and then repair.

Your database engine services upgrade failed. You'll need to repair it by running setup /action=repair /instancename=MSSQLSERVER after fixing the problem that caused it to fail in the first place.

2
  • +1 and thanks for the solution.. I have did the same and it resolved everything except reporting services - Native (i have attached the screenshot in my question).. Any Suggestion how to resolve this? Commented Feb 4, 2014 at 12:49
  • Also, I would be glad if you could answer my another question dba.stackexchange.com/questions/58204/… as I have almost no knowledge about upgrade Commented Feb 4, 2014 at 12:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.