"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
>
Anyone else have this error and solved it please?
Thanks in advance for any help.
--
leswilkinson
------------------------------------------------------------------------
leswilkinson's Profile: http://forums.techarena.in/member.php?userid=27673
View this thread: http://forums.techarena.in/showthread.php?t=726019
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.
Since this is for a consumer issue, please call 1.800.936.5700 and open up a
support case.
Diana Smith [MSFT] <dias...@hotmail.com>
CSS Security Team
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gordon Lamb" <Gordo...@discussions.microsoft.com> wrote in message
news:93AF1883-72A0-4EBA...@microsoft.com...
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