SQL Server set up failure

Asked By King Lopezs 30 points N/A Posted on - 10/06/2012

Hi.

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 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.

OK

 

What should I do?

Thanks for any input on this.

• Status: Open
• Question Views: 1130
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by LyanaHay

Go To Solution

Answered By Nicke Baker 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.

Regards,

Nicke

About Nicke Baker

Questions
0

Answers
671

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 10/06/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By LyanaHay 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

MPT_AGENT_CORE_CNI

SQL_Engine_Core_Inst

SQL_Replication_Core_Inst

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.

 

About LyanaHay

Questions
2

Answers
106

Best Answers
64

• Vote Up 0 Vote Down

• Posted on - 12/25/2012
• Question Category: MS SQL Server