Error Code: 0x6DBC Updates were not installed Microsoft SQL Server 2005 Express Edition Service Pack 2

Error Code: 0x6DBC

Updates were not installed Microsoft SQL Server 2005 Express Edition
Service Pack 2

About the only thing I use SQL Server for is ACT! 2007 (version 9).

Norton AntiVirus.
Windows XP Media Center Edition.
--

"J. J."

The ACT! application removes the ability for the SQL Express update to
upgrade the database engine. This is a known issue that ACT! is working on
addressing by providing information on their web site. I am not sure if they
have done this yet.

Anyways, can you post the contents of your summary.txt to this posting so I
can take a look. The summary.txt should be located in:
%programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix.

Thanks,
Peter Saddow

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



"JDJ" <jj@invalid.invalid> wrote in message
news:3qn5031gvsg47jbcj598oo7d9u4c0uhku5@4ax.com...
> Error Code: 0x6DBC
>
> Updates were not installed Microsoft SQL Server 2005 Express Edition
> Service Pack 2
>
> About the only thing I use SQL Server for is ACT! 2007 (version 9).
>
> Norton AntiVirus.
> Windows XP Media Center Edition.
> --
>
> "J. J."

Peter,
I got here after I searched the knowledge base for 0x6DBC after trying to
load SP2 for SQL. Using ACT too
Here is the content of the summary file.
I'll look at the ACT support also and will post a response here when fixed.
Thanks,
Danny

Time: 04/29/2007 11:00:12.250
KB Number: KB921896
Machine: DANNY
OS Version: Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

************************************************** ********************************
Prerequisites Check & Status
SQLSupport: Passed

************************************************** ********************************
Products Detected Language Level Patch Level
Platform Edition
Express Database Services (ACT7) ENU SP1 2005.090.2170.00
x86 EXPRESS

************************************************** ********************************
Products Disqualified & Reason
Product Reason

************************************************** ********************************
Processes Locking Files
Process Name Feature Type User Name
PID

************************************************** ********************************
Product Installation Status
Product : Express Database Services (ACT7)
Product Version (Previous): 2170
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_S QLEXPR.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 28092
Error Description : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------

************************************************** ********************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 28092

Unfortuantely as of May 1, 2007, ACT has not posted anything related to this
problem on their website with one exception. They have provided instructions
on how to turn off the automatic update for KB921896... which clearly does
not solve the problem.

Please post a reply if you pick up any helpful hints on this.... Thanks

"Danny" wrote:

> Peter,
> I got here after I searched the knowledge base for 0x6DBC after trying to
> load SP2 for SQL. Using ACT too
> Here is the content of the summary file.
> I'll look at the ACT support also and will post a response here when fixed.
> Thanks,
> Danny
>
> Time: 04/29/2007 11:00:12.250
> KB Number: KB921896
> Machine: DANNY
> OS Version: Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
> Package Language: 1033 (ENU)
> Package Platform: x86
> Package SP Level: 2
> Package Version: 3042
> Command-line parameters specified:
> /quiet
> /allinstances
> Cluster Installation: No
>
> ************************************************** ********************************
> Prerequisites Check & Status
> SQLSupport: Passed
>
> ************************************************** ********************************
> Products Detected Language Level Patch Level
> Platform Edition
> Express Database Services (ACT7) ENU SP1 2005.090.2170.00
> x86 EXPRESS
>
> ************************************************** ********************************
> Products Disqualified & Reason
> Product Reason
>
> ************************************************** ********************************
> Processes Locking Files
> Process Name Feature Type User Name
> PID
>
> ************************************************** ********************************
> Product Installation Status
> Product : Express Database Services (ACT7)
> Product Version (Previous): 2170
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_S QLEXPR.EXE
> SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
> Error Number : 28092
> Error Description : Unable to install Windows Installer MSI file
> ----------------------------------------------------------------------------------
>
> ************************************************** ********************************
> Summary
> One or more products failed to install, see above for details
> Exit Code Returned: 28092
>
>

Download the update and install it manually. You WILL need the original
install CD.

--
tbark


"JDJ" wrote:

> Error Code: 0x6DBC
>
> Updates were not installed Microsoft SQL Server 2005 Express Edition
> Service Pack 2
>
> About the only thing I use SQL Server for is ACT! 2007 (version 9).
>
> Norton AntiVirus.
> Windows XP Media Center Edition.
> --
>
> "J. J."
>

Download the update and install it manually. You WILL need the original
install CD.

--
tbark


"JDJ" wrote:

> Error Code: 0x6DBC
>
> Updates were not installed Microsoft SQL Server 2005 Express Edition
> Service Pack 2
>
> About the only thing I use SQL Server for is ACT! 2007 (version 9).
>
> Norton AntiVirus.
> Windows XP Media Center Edition.
> --
>
> "J. J."
>

[amusedgeek]

I downloaded the SP and tried to install it - still would not install.
Time to check the log files. Looked at the hotfix.log and it was complaining about not being able to read the Debug value at HKLM/Software/Policies/Microsoft/Windows/Installer. I opened regedit and went to that location, no such value so I create a blank string named Debug.
SP2 installed without a hitch.
Note: This may or may not be relevent, I did try to run subinacl earlier and there was no noticable effect but it may have contributed to the fix.
Addendum: If you look at Help & About in the SQL Manager it shows sp2, but Automatic Updates still insists it is not installed.