SQL Server set up failure

Asked By 30 points N/A Posted on -


I guess I need a little help now. I try to avoid in-place as much possible since I prefer starting from scratch when I do OS and application installations. I have a development SQL Server 2005 which has run on a Windows Server 2003 Enterprise computer (64bit) for the last three years.

I installed SQL Server 2008 R2 pretty much successfully. However, the SQL Server Agent service wasn’t updated and was unable to start. I immediately ran the “Repair” option but the issue was not resolved. I searched for a changing executable registry path targeting the new folder location to fix the issue.

There were no discrepancies in the databases and the corresponding connected applications. I then proceeded by updating with the “Cumulative Update package 2″ for the SQL Server 2008 R2(http://support.microsoft.com/kb/2072493)

Then I suddenly got this error message:

SQL Server failure

SQL Server Setup Failure.

SQL Server Setup has encountered the following error:

A failure was detected for a previous installation, patch, or repay for instance MSSQSERVER during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_CoreInst,MPTAGENT_CORE_CNI,]. In order to apply this patch package (K82072493), you must resolve any issues with the previous operation that failed, View the summary.txt log to deternr.e why the previous operation faded.

Error code 0x84820001.



What should I do?

Thanks for any input on this.

Best Answer by LyanaHay
Answered By 0 points N/A #192319

SQL Server set up failure


Hello King,

The error seems to be caused by previous installations or files of the SQL server application that you have on your computer, and therefore to resolve it you will need to first of uninstall the files completely, and then run CCleaner to remove those files. After that you can reinstall it.



Best Answer
Best Answer
Answered By 0 points N/A #192320

SQL Server set up failure


Hi King Lopezs,

 I got solution for your problem performs following things in order to overcome this problem:

1] Look for registry entry in registry editor ->  HKEY_LOCAL_MACHINE -> SOFTWARE -> Microsoft ->Microsoft SQL Server -> MSSQL10_50.MSSQLSERVER -> Configuration State

2] Check these entries




3] All values are set to 3 change them to 1

4] Close editor and SQL Server 2008 R2 update again.

This solution should work for you.


Login/Register to Answer

Related Questions