Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
    
Instead of screenshot, better to post the exact error message ! –  Kin Feb 3 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 Feb 3 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 Feb 4 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 Feb 4 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? –  NewAtProgramming Feb 4 at 9:43

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer
    
+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? –  NewAtProgramming Feb 4 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 –  NewAtProgramming Feb 4 at 12:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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