SQL Server set up failure

Asked By 30 points N/A Posted on -
qa-featured

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

OK

 

What should I do?

Thanks for any input on this.

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

SQL Server set up failure

qa-featured

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

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

SQL Server set up failure

qa-featured

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.

 

Login/Register to Answer

Related Questions