When trying to install SQL Server 2008R2 SP1 the following error can appear:

 

A Failure was detected for a previous installation, patch, or repair For instance ?MSSQLSERVER? during configuration for features [SQL_Engine_Core_Shared, SQL_POWERShell_Engine_CNS, CommonFiles, CommonFiles_Loc].In order to apply this patch package (KB2072493), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

Error code 0x84B20001.

The solution suggested by some forums was to update some registry entries. In my situation the following registry keys needed modification:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState

  • CommonFiles
  • CommonFiles_Loc
  • SQL_Engine_Core_Shared
  • SQL_POWERShell_Engine_CNS

 

...

The REG_DWORD values were set to 3 and I had to change them to 1. This change solved my problem and the SQL Server 2008 R2 SP1 installed successfully. 

Depending on the feature list from your error message, search the corresponding registry keys and modify their REG_DWORD values from 3 to 1:

 

 


13 comments

Comment from: Fred Peters [Visitor]
Fred PetersThis worked for me also, of course with different entries set to 3. I also had errors on the SqlExpress installation, which were found under the path:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS.

Thanks!
07/26/12 @ 04:37
Comment from: admin [Member] Email
I'm glad I helped :)
08/26/12 @ 09:49
Comment from: Thorsten Franzke [Visitor] Email
Thorsten FranzkeThanks to you! This solved my problem. Over here it's been yet another "SQL configuration state".

This has been bothering me for month. You made my day!
01/04/13 @ 00:59
Comment from: Wilfredo Sanchez [Visitor]
Wilfredo SanchezThanks for your help
03/25/13 @ 19:33
Comment from: admin [Member] Email
You're welcome!
03/25/13 @ 20:09
Comment from: Suri [Visitor] Email
SuriTITLE: Microsoft SQL Server 2012 Service Pack 1 Setup
------------------------------

The following error has occurred:

Unable to open Windows Installer file 'E:\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi'.

Windows Installer error message: The system cannot open the device or file specified.
.



Can some One Helpme out please.
04/17/13 @ 23:42
Comment from: admin [Member] Email
@Suri
I seems that you have a corrupted msi file. Try to download another copy of the installation kit and start installation from local.
Also you can go to properties \ security section and select "Unblock".
Please tell us if this solved your issue.
04/18/13 @ 09:46
Comment from: Ayman Aldubaie [Visitor]
Ayman AldubaieThanks a lot ,,
it's really worked :)
08/24/13 @ 15:25
Comment from: ken [Visitor]
kenTITLE: SQL Server Setup failure.
------------------------------

SQL Server Setup has encountered the following error:

The action type 'ExecuteWorkflowAction' is not valid for the WorkflowIdentity element. The only valid action type is ExecuteWorkflowAction.

Error code 0x84B20001.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0xEC7E6608%25400xF762992B%25401202%25401

------------------------------
BUTTONS:

OK
------------------------------
04/04/14 @ 06:22
Comment from: Thomas Quee [Visitor]
Thomas QueeThis worked very well for me too, thank you for your help.
06/18/14 @ 16:53
Comment from: zeina [Visitor]
zeinaTITLE: SQL Server Setup failure.
------------------------------

SQL Server Setup has encountered the following error:

The required MSI package 'c:\b271a85718868ece2268d5\1033_ENU_LP\x64\setup\SqlWriter.msi' doesn't exist.

Error code 0x84B20001.
08/01/14 @ 17:31
Comment from: tranngochai [Visitor]
tranngochai
sql server setup has encountered the following error
the installation media is corrupted.it does not contain the folder'1033'
error code 0x84b20001
09/05/14 @ 07:25
Comment from: usman suleman [Visitor] Email
usman sulemanSQL Server Setup failure.

SQL Server Setup has encountered the following error:

The installation media is corrupted. It does not contain the folder '1033'.

Error code 0x84B20001.

06/14/15 @ 18:21

This post has 1 feedback awaiting moderation...

Leave a comment


Your email address will not be revealed on this site.
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)