RE: What is error code 0x80070643 during MSSQL Server 2005 SP2 upd

Hi Gents,

I have exactly the same problem.

I can not install SQL Server Express Edition SP2 either.

I have tried direct from MS update and via wsus 3 sp1.

The Logo files shows

14:29:35:852+0800 1 182 101 {32CB94A3-B1EF-40DE-86A8-8FBF053D800E} 100 80070643 MicrosoftUpdate Failure Content
Install Installation Failure: Windows failed to install the following update
with error 0x80070643: Microsoft SQL Server 2005 Express Edition Service Pack
2 (KB 921896).
2008-09-04 14:29:48:430 6460 10ec Handler : MSI transaction completed.
MSI: 0x00000000, Handler: 0x00000000, Source: No, Reboot: 0

Any help would be apprecated.

"alistair" wrote:

> go to the following site and you will find your error under miscellaneous
> error codes. http://support.microsoft.com/ph/6527/
> --
> matt
>
>
> "fuzzy" wrote:
>
> > I am receiving the following error during online widows update for MSSQL
> > Server 2005:
> >
> > "Installation Failure: Windows failed to install the following update with
> > error 0x80070643: Microsoft SQL Server 2005 Express Edition Service Pack 2
> > (KB 921896)."
> >
> > I am unable to locate any support info on microsoft's website.
> >
> > Any help will be appreciated.
> >
> > Thanks,
> > Fuzzy
> >

Hello,

Since this is for a consumer issue, please call 1.800.936.5700 and open up a
support case.

Diana Smith [MSFT] <diasmith@hotmail.com>
CSS Security Team

This posting is provided "AS IS" with no warranties, and confers no rights.




"Gordon Lamb" <GordonLamb@discussions.microsoft.com> wrote in message
news:93AF1883-72A0-4EBA-8FB6-17253AB1BD03@microsoft.com...
> Hi Gents,
>
> I have exactly the same problem.
>
> I can not install SQL Server Express Edition SP2 either.
>
> I have tried direct from MS update and via wsus 3 sp1.
>
> The Logo files shows
>
> 14:29:35:852+0800 1 182 101 {32CB94A3-B1EF-40DE-86A8-8FBF053D800E} 100
> 80070643 MicrosoftUpdate Failure Content
> Install Installation Failure: Windows failed to install the following
> update
> with error 0x80070643: Microsoft SQL Server 2005 Express Edition Service
> Pack
> 2 (KB 921896).
> 2008-09-04 14:29:48:430 6460 10ec Handler : MSI transaction completed.
> MSI: 0x00000000, Handler: 0x00000000, Source: No, Reboot: 0
>
> Any help would be apprecated.
>
> "alistair" wrote:
>
>> go to the following site and you will find your error under miscellaneous
>> error codes. http://support.microsoft.com/ph/6527/
>> --
>> matt
>>
>>
>> "fuzzy" wrote:
>>
>> > I am receiving the following error during online widows update for
>> > MSSQL
>> > Server 2005:
>> >
>> > "Installation Failure: Windows failed to install the following update
>> > with
>> > error 0x80070643: Microsoft SQL Server 2005 Express Edition Service
>> > Pack 2
>> > (KB 921896)."
>> >
>> > I am unable to locate any support info on microsoft's website.
>> >
>> > Any help will be appreciated.
>> >
>> > Thanks,
>> > Fuzzy
>> >

This is the page that comes up first on googling for "Installation
Failure: Windows failed to install the following update with error
0x80070643: Microsoft SQL Server 2005 Service Pack 2 (KB 921896). "
which is, I expect, what a lot of people google for when they encounter
this problem. I am therefore leaving my solution here in hopes that it
is helpful to the next man.

This error can be caused by the file DTSSVCPERF.INI being missing. I
discovered this examining the DTS9 hotfix install log file
(DTS9_Hotfix_KB921896_sqlrun_dts.msp.log), wherein this error message
can be found:


Code:
--------------------
Error copying file(c:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSSVCPERF.INI) to file(c:\Program Files\Microsoft SQL Server\90\DTS\Binn\perf-DTSSVCPERF.INI). Error code 2
--------------------


I obtained a copy of DTSSVCPERF.INI, and for good measure DTSSVCPERF.H,
from an installation which had them. Since these files are not easily
locatable if they are missing I am including them below. They should
both go in the c:\Program Files\Microsoft SQL Server\90\DTS\Binn\
directory:

DTSSVCPERF.INI:

Code:
--------------------

[info]
drivername=MsDtsServer
symbolfile=dtssvcperf.h

[languages]
009=English

[objects]
PRFOBJ_DTS_SERVICE_START_009_NAME=SQLServer:SSIS Service

[text]
PRFOBJ_DTS_SERVICE_START_009_NAME=SQLServer:SSIS Service
PRFOBJ_DTS_SERVICE_START_009_HELP=SQL Server Integration Services Service performance counters.

DTS_SERVICE_PACKAGE_COUNT_009_NAME=SSIS Package Instances
DTS_SERVICE_PACKAGE_COUNT_009_HELP=The number of package instances currently running.

--------------------


DTSSVCPERF.H:

Code:
--------------------

//************************************************** **************************
// Copyright (c) 2004 Microsoft Corporation.
//
// Purpose:
// Performance counters for the SSIS Service.
//
//************************************************** **************************

#pragma once

#define PRFOBJ_DTS_SERVICE_START 0
#define DTS_SERVICE_PACKAGE_COUNT 2

--------------------


I trust that Microsoft will not mind this minor copyright violation as
the dissemination of these files will only serve to fix their customers'
problems.

Please note that while this solved the problem for me there could be
other causes. You need to look at your log files in C:\Program
Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\ for the most
recent summary and the any file referencing the KB921896. Scrolling to
the end, then back up looking for errors will hopefully let you
determine whether this fix will work for you.


--
sorpigal
------------------------------------------------------------------------
sorpigal's Profile: http://forums.techarena.in/members/sorpigal.htm
View this thread: http://forums.techarena.in/windows-update/726019.htm

http://forums.techarena.in