Error installing (KB 921896)

[DavidW]

This is listed as an Important Update:

Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)

Download size: 56.4 MB

You may need to restart your computer for this update to take effect.

Update type: Important

This service pack upgrades all Microsoft SQL Server 2005 Express Edition
instances and components to Service Pack 2 (SP2). If you need additional
installation options, you should download this service pack at the Microsoft
Download Center. For more information, see Microsoft Knowledge Base article
921896.

I tried to install and this is the error I get: WindowsUpdate_00002B33

What should I do? Is it truly an Important update and if so, how do I
install it?

[Peter Saddow [Microsoft]]

Looks like you have SQL Server 2005 Express Edition installed.

Could you post the contents of the summary.txt log located at C:\Program
Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We can then debug
the issue.

[DavidW]

I, too, am running ACT version 2007 that relies upon SQL Server for the
Desktop. I've tried stopping the SQL Server Process while changing its type
to "Manual" from "Automatic". I've tried "Manual" while it was "running".
SQL Server's normal status after a reboot and without starting ACT is
"running" and "automatic". Still I am unsuccessful in Service Pack 2's
installation. I get Error Code: 0x2B26.

BTW: I've been wanting to buy a new laptop with Vista but the ACT
application needs elements of SQL Server that Vista reportedly doesn't
support. Does Service Pack 2 address this deficiency?

Thanks for the help!

[Peter Saddow [Microsoft]]

Looks like the Express service is disabled. The service needs to be startable
for the upgrade to complete. Go to Administrate Tools and then Services. Look
for the entry called "SQL Server (ACT7)". Right-click on the entry and choose
properties. You should see the "Startup Type" is disabled. Change the
"Startup Type" to manual. Rerun the installation through Microsoft Update.

[Steve Kuckuk]

I've also received the same error, and in reading the thread from the last
few days I think I discovered "something" with my ACT which gets in the way,
but it doesn't appear to be quite the same as the previous user...

Below is the "summary" file as requested from the earlier poster

Thanks for any help you can provide...

[Dr. George]

I recently successfully upgraded to Win Vista from Win XP. I have an HP
Media Center computer. I am having my first big Vista probelm. Win Vista
Update notified me that KB 921896 needed to be downloaded and installed. It
appears to download and start to install. Sudddenly it stops and I get an
error code 2B22 or 2B26. I spent 3 hours with MS Online Tech Chat India.
There was no explanation of the error codes. The tech remotely installed KB
921896 from the MS download page. I rebooted and still couldn't download the
Win Vista Update item. I was told that MS SLQ Server 2005 is incompatible
with Vista. What am I supposed to do? I cannot use Outlook Business
Contacts 2007. I think the MS Accounting 2007 needs SQL too. My Hotfix data
is below. Thanks!

[Dr. George]

What password? What account? ...when there is only one administrator
account on the computer?

Thanks!

[Mw]

Steve... I have the exact same issue with ACT7... It appears that the
Windows Update program needs the authentic process for logging to the
SLServer instance to be in the "Windows Authentication" mode instead of
"Mixed Authentication" mode which is the ACT7 default. Unfortuantely, ACT7
insulates the user from having easy access to change this authentication
process. Thus, Windows Update looks to login to SQLServer using an
authentication process that is not valid with the way that ACT7 has setup the
SQLServer instance. I do not know how to get around this... but this is the
key to the problem... I am hoping Microsoft or ACT (not helpful) can advise
as to how to temporarily active SQLServer to the "Widows Authentication" mode.

[Mw]

Please note that ACT7 users are setup to use the "Local System" built in
account of SQLServer 2005 Express... which normally does not have a password
required (or revealed).... Clearly the Windows Update process is not able to
logon (fails) with this default account. Should I try to logon by some sort
of other process (not sure how to do this)... There are options to use other
sorts of account types.... but it is unclear how to set them up.

I have the exact same issue with ACT7... It appears that the
Windows Update program needs the authentic process for logging to the
SLServer instance to be in the "Windows Authentication" mode instead of
"Mixed Authentication" mode which is the ACT7 default. Unfortuantely, ACT7
insulates the user from having easy access to change this authentication
process. Thus, Windows Update looks to login to SQLServer using an
authentication process that is not valid with the way that ACT7 has setup the
SQLServer instance. I do not know how to get around this... but this is the
key to the problem... I am hoping Microsoft or ACT (not helpful) can advise
as to how to temporarily active SQLServer to the "Widows Authentication" mode.

[Tombrown]

I also tried to install the update twice and failed. Here is the summary.txt file.

Thanks

Time: 10/27/2007 23:53:30.921
KB Number: KB921896
Machine: TOMLAP
OS Version: Microsoft Windows XP Professional 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
Express Database Services (SQLExpress) ENU SP1 x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason
Express Database Services (ACT7) User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication

**********************************************************************************
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 : Not Applied
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 11046
Error Description : User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
----------------------------------------------------------------------------------
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : Client_Components,Connectivity
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
Exit Code Returned: 11046

[Humanist]

RE: Error installing (KB 921896)
-------------------------------
(I must say firstly sory about my english, i'm still working on it ;))

Administrative Tools --> Services

You have to make sure these are starting automaticly

SQL Server (SQLEXPRESS or SQL)
SQL Server Active Directory Helper (Optional)
SQL Server Browser
SQL Server VSS Writer

If they are disabled change them automatic start and try to install KB 921896 again.

Best Wishes
Onur Oztemizel

[SYA]

Hi Peter

I am having a similar problem installing the update for SQL Server Express
Edition. I checked my summary.txt and it appears that installer MSI doesn't
load (see below). How can I rectify this?

Thanks


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

"Peter Saddow [Microsoft]" wrote:

> Could you post the contents of the summary.txt log located at
> %programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We can
> then debug the issue.
>
> Thanks,
> Peter Saddow
>
>
> "GPO" wrote:
>
> > The update is called: Microsoft SQL Server 2005 Express Edition Service Pack
> > 2 (KB 921896). My computer seems to think it was downloaded, and each time I
> > retry to update, it seems to go to an install function (which fails). I
> > wonder if there is a way to wipe the download from my system and start over.
> > Here are the error details:
> >
> > Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
> > Installation date: ‎3/‎8/‎2007 3:01 AM
> > Installation status: Failed
> > Error details: Code 2B22
> > Update type: Important
> > This service pack upgrades all Microsoft SQL Server 2005 Express Edition
> > instances and components to Service Pack 2 (SP2). If you need additional
> > installation options, you should download this service pack at the Microsoft
> > Download Center. For more information, see Microsoft Knowledge Base article
> > 921896.
> > More information:
> > http://support.microsoft.com/kb/921896
> > More information:
> > http://support.microsoft.com
> >
> > Any help would be appreciated.
> >
> > "Peter Saddow [Microsoft]" wrote:
> >
> > > You are encountering a different problem than the previous person. Try
> > > scanning and downloading again, maybe there was some network issue when the
> > > update was downloading. If you continue to encounter a problem please post a
> > > new message and let us know which update you are trying to download.
> > >
> > > Thanks,
> > > Peter Saddow [Microsoft]
> > >
> > > "GPO" wrote:
> > >
> > > > I am having the same issue. My download froze at 82% and now it wants to
> > > > install only, and cannot complete the install, but won't go away as saying I
> > > > should try again. Any thoughts?
> > > >
> > > > "Peter Saddow [Microsoft]" wrote:
> > > >
> > > > > Looks like the Express service is disabled. The service needs to be startable
> > > > > for the upgrade to complete. Go to Administrate Tools and then Services. Look
> > > > > for the entry called "SQL Server (ACT7)". Right-click on the entry and choose
> > > > > properties. You should see the "Startup Type" is disabled. Change the
> > > > > "Startup Type" to manual. Rerun the installation through Microsoft Update.
> > > > >
> > > > > "DavidW" wrote:
> > > > >
> > > > > > Sure thing:
> > > > > >
> > > > > > Time: 03/07/2007 18:51:52.227
> > > > > > KB Number: KB921896
> > > > > > Machine: DAVID2
> > > > > > OS Version: Professional (Build 6000)
> > > > > > 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
> > > > > > Express Database Services (SQLExpress) ENU SP1
> > > > > > x86 EXPRESS
> > > > > >
> > > > > > **********************************************************************************
> > > > > > Products Disqualified & Reason
> > > > > > Product Reason
> > > > > > Express Database Services (ACT7) Service was found to be disabled
> > > > > >
> > > > > > **********************************************************************************
> > > > > > 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 : Not Applied
> > > > > > Log File :
> > > > > > SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
> > > > > > Error Number : 11059
> > > > > > Error Description : Service was found to be disabled
> > > > > > ----------------------------------------------------------------------------------
> > > > > > Product : Express Database Services (SQLExpress)
> > > > > > Product Version (Previous):
> > > > > > Product Version (Final) :
> > > > > > Status : Not Applied
> > > > > > Log File :
> > > > > > SQL Express Features : Client_Components,Connectivity
> > > > > > Error Number : 0
> > > > > > Error Description :
> > > > > > ----------------------------------------------------------------------------------
> > > > > >
> > > > > > **********************************************************************************
> > > > > > Summary
> > > > > > Service was found to be disabled
> > > > > > Exit Code Returned: 11059
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Peter Saddow [Microsoft]" wrote:
> > > > > >
> > > > > > > Looks like you have SQL Server 2005 Express Edition installed.
> > > > > > >
> > > > > > > Could you post the contents of the summary.txt log located at C:\Program
> > > > > > > Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We can then debug
> > > > > > > the issue.
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Peter Saddow [MSFT]
> > > > > > >
> > > > > > >
> > > > > > > "DavidW" wrote:
> > > > > > >
> > > > > > > > This is listed as an Important Update:
> > > > > > > >
> > > > > > > > Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
> > > > > > > >
> > > > > > > > Download size: 56.4 MB
> > > > > > > >
> > > > > > > > You may need to restart your computer for this update to take effect.
> > > > > > > >
> > > > > > > > Update type: Important
> > > > > > > >
> > > > > > > > This service pack upgrades all Microsoft SQL Server 2005 Express Edition
> > > > > > > > instances and components to Service Pack 2 (SP2). If you need additional
> > > > > > > > installation options, you should download this service pack at the Microsoft
> > > > > > > > Download Center. For more information, see Microsoft Knowledge Base article
> > > > > > > > 921896.
> > > > > > > >
> > > > > > > > I tried to install and this is the error I get: WindowsUpdate_00002B33
> > > > > > > >
> > > > > > > > What should I do? Is it truly an Important update and if so, how do I
> > > > > > > > install it?
> > > > > > > >

[Sam Holbrook]

Was there a resolution to this problem?

"SYA" <SYA@discussions.microsoft.com> wrote in message
news:49687CD4-3DAC-4263-9475-D1AD50B72094@microsoft.com...
> Hi Peter
>
> I am having a similar problem installing the update for SQL Server Express
> Edition. I checked my summary.txt and it appears that installer MSI
> doesn't
> load (see below). How can I rectify this?
>
> Thanks
>
>
> Product Installation Status
> Product : Express Database Services (MSSMLBIZ)
> Product Version (Previous): 2047
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
> SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
> Error Number : -2146885628
> Error Description : Unable to install Windows Installer MSI file
>
> "Peter Saddow [Microsoft]" wrote:
>
>> Could you post the contents of the summary.txt log located at
>> %programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We can
>> then debug the issue.
>>
>> Thanks,
>> Peter Saddow
>>
>>
>> "GPO" wrote:
>>
>> > The update is called: Microsoft SQL Server 2005 Express Edition
>> > Service Pack
>> > 2 (KB 921896). My computer seems to think it was downloaded, and each
>> > time I
>> > retry to update, it seems to go to an install function (which fails).
>> > I
>> > wonder if there is a way to wipe the download from my system and start
>> > over.
>> > Here are the error details:
>> >
>> > Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
>> > Installation date: ?3/?8/?2007 3:01 AM
>> > Installation status: Failed
>> > Error details: Code 2B22
>> > Update type: Important
>> > This service pack upgrades all Microsoft SQL Server 2005 Express
>> > Edition
>> > instances and components to Service Pack 2 (SP2). If you need
>> > additional
>> > installation options, you should download this service pack at the
>> > Microsoft
>> > Download Center. For more information, see Microsoft Knowledge Base
>> > article
>> > 921896.
>> > More information:
>> > http://support.microsoft.com/kb/921896
>> > More information:
>> > http://support.microsoft.com
>> >
>> > Any help would be appreciated.
>> >
>> > "Peter Saddow [Microsoft]" wrote:
>> >
>> > > You are encountering a different problem than the previous person.
>> > > Try
>> > > scanning and downloading again, maybe there was some network issue
>> > > when the
>> > > update was downloading. If you continue to encounter a problem please
>> > > post a
>> > > new message and let us know which update you are trying to download.
>> > >
>> > > Thanks,
>> > > Peter Saddow [Microsoft]
>> > >
>> > > "GPO" wrote:
>> > >
>> > > > I am having the same issue. My download froze at 82% and now it
>> > > > wants to
>> > > > install only, and cannot complete the install, but won't go away as
>> > > > saying I
>> > > > should try again. Any thoughts?
>> > > >
>> > > > "Peter Saddow [Microsoft]" wrote:
>> > > >
>> > > > > Looks like the Express service is disabled. The service needs to
>> > > > > be startable
>> > > > > for the upgrade to complete. Go to Administrate Tools and then
>> > > > > Services. Look
>> > > > > for the entry called "SQL Server (ACT7)". Right-click on the
>> > > > > entry and choose
>> > > > > properties. You should see the "Startup Type" is disabled. Change
>> > > > > the
>> > > > > "Startup Type" to manual. Rerun the installation through
>> > > > > Microsoft Update.
>> > > > >
>> > > > > "DavidW" wrote:
>> > > > >
>> > > > > > Sure thing:
>> > > > > >
>> > > > > > Time: 03/07/2007 18:51:52.227
>> > > > > > KB Number: KB921896
>> > > > > > Machine: DAVID2
>> > > > > > OS Version: Professional (Build 6000)
>> > > > > > 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
>> > > > > > Express Database Services (SQLExpress) ENU SP1
>> > > > > > x86 EXPRESS
>> > > > > >
>> > > > > > **********************************************************************************
>> > > > > > Products Disqualified & Reason
>> > > > > > Product Reason
>> > > > > > Express Database Services (ACT7) Service was found to
>> > > > > > be disabled
>> > > > > >
>> > > > > > **********************************************************************************
>> > > > > > 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 : Not Applied
>> > > > > > Log File :
>> > > > > > SQL Express Features :
>> > > > > > SQL_Data_Files,SQL_Engine,SQL_SharedTools
>> > > > > > Error Number : 11059
>> > > > > > Error Description : Service was found to be disabled
>> > > > > > ----------------------------------------------------------------------------------
>> > > > > > Product : Express Database Services
>> > > > > > (SQLExpress)
>> > > > > > Product Version (Previous):
>> > > > > > Product Version (Final) :
>> > > > > > Status : Not Applied
>> > > > > > Log File :
>> > > > > > SQL Express Features : Client_Components,Connectivity
>> > > > > > Error Number : 0
>> > > > > > Error Description :
>> > > > > > ----------------------------------------------------------------------------------
>> > > > > >
>> > > > > > **********************************************************************************
>> > > > > > Summary
>> > > > > > Service was found to be disabled
>> > > > > > Exit Code Returned: 11059
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > > "Peter Saddow [Microsoft]" wrote:
>> > > > > >
>> > > > > > > Looks like you have SQL Server 2005 Express Edition
>> > > > > > > installed.
>> > > > > > >
>> > > > > > > Could you post the contents of the summary.txt log located at
>> > > > > > > C:\Program
>> > > > > > > Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We
>> > > > > > > can then debug
>> > > > > > > the issue.
>> > > > > > >
>> > > > > > > Thanks,
>> > > > > > > Peter Saddow [MSFT]
>> > > > > > >
>> > > > > > >
>> > > > > > > "DavidW" wrote:
>> > > > > > >
>> > > > > > > > This is listed as an Important Update:
>> > > > > > > >
>> > > > > > > > Microsoft SQL Server 2005 Express Edition Service Pack 2
>> > > > > > > > (KB 921896)
>> > > > > > > >
>> > > > > > > > Download size: 56.4 MB
>> > > > > > > >
>> > > > > > > > You may need to restart your computer for this update to
>> > > > > > > > take effect.
>> > > > > > > >
>> > > > > > > > Update type: Important
>> > > > > > > >
>> > > > > > > > This service pack upgrades all Microsoft SQL Server 2005
>> > > > > > > > Express Edition
>> > > > > > > > instances and components to Service Pack 2 (SP2). If you
>> > > > > > > > need additional
>> > > > > > > > installation options, you should download this service pack
>> > > > > > > > at the Microsoft
>> > > > > > > > Download Center. For more information, see Microsoft
>> > > > > > > > Knowledge Base article
>> > > > > > > > 921896.
>> > > > > > > >
>> > > > > > > > I tried to install and this is the error I get:
>> > > > > > > > WindowsUpdate_00002B33
>> > > > > > > >
>> > > > > > > > What should I do? Is it truly an Important update and if
>> > > > > > > > so, how do I
>> > > > > > > > install it?
>> > > > > > > >

[BD]

I have the same problem as this most in this thread and attach my Hotfix log.
Can you help please? It is so frustrating - 45 attempts without success!

07/11/2008 12:21:41.234
================================================================================
07/11/2008 12:21:41.234 Hotfix package launched
07/11/2008 12:21:41.375 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
07/11/2008 12:21:41.375 Registry: Read registry key value "CommonFilesDir",
string value = C:\Program Files\Common Files
07/11/2008 12:21:41.375 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
07/11/2008 12:21:41.375 Registry: Read registry key value "ProgramFilesDir",
string value = C:\Program Files
07/11/2008 12:21:41.375 Local Computer:
07/11/2008 12:21:41.375 Target Details: YOUR-B5698FD8A0
07/11/2008 12:21:41.375 commonfilesdir = C:\Program Files\Common Files
07/11/2008 12:21:41.375 lcidsupportdir = c:\0182380578d681c4efcd\1033
07/11/2008 12:21:41.375 programfilesdir = C:\Program Files
07/11/2008 12:21:41.375 programfilesdir_wow = C:\Program Files
07/11/2008 12:21:41.375 supportdir = c:\0182380578d681c4efcd
07/11/2008 12:21:41.375 supportdirlocal = c:\0182380578d681c4efcd
07/11/2008 12:21:41.375 windir = C:\WINDOWS
07/11/2008 12:21:41.390 winsysdir = C:\WINDOWS\system32
07/11/2008 12:21:41.390 winsysdir_wow = C:\WINDOWS\SysWOW64
07/11/2008 12:21:41.390
07/11/2008 12:21:41.390 Enumerating applicable products for this patch
07/11/2008 12:21:41.390 Found SQL 2005 Express product definition
07/11/2008 12:21:42.843 Enumeration: Determining QFE level for product
instance MSSMLBIZ
07/11/2008 12:21:42.859 Enumeration: Associated hotfix build information not
found for the following file: c:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
07/11/2008 12:21:42.859 Enumeration: Found following QFE level for product
instance MSSMLBIZ: 2047
07/11/2008 12:21:42.859 Enumeration: Determining GDR branching Hotfix for
product instance MSSMLBIZ
07/11/2008 12:21:42.859 Enumeration: Associated hotfix build information not
found for the following file: c:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
07/11/2008 12:21:42.859 Enumeration: No GDR branch Hotfix found for product
instance MSSMLBIZ
07/11/2008 12:21:42.875 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
07/11/2008 12:21:42.875 Registry: Read registry key value "CommonFilesDir",
string value = C:\Program Files\Common Files
07/11/2008 12:21:42.875 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
07/11/2008 12:21:42.875 Registry: Read registry key value "ProgramFilesDir",
string value = C:\Program Files
07/11/2008 12:21:42.875 Product discovery completed during the install
process for MSSMLBIZ
07/11/2008 12:21:42.875 SP Level check completed during the install process
for MSSMLBIZ
07/11/2008 12:21:42.875 Product language check completed during the install
process for MSSMLBIZ
07/11/2008 12:21:42.875 Product version check completed during the install
process for MSSMLBIZ
07/11/2008 12:21:42.875 Command-line instance name check completed during
the install process
07/11/2008 12:21:42.875 SKU check completed during the install process for
MSSMLBIZ
07/11/2008 12:21:42.875 Baseline build check completed during the
installation process for MSSMLBIZ
07/11/2008 12:21:42.875 Baseline build check completed during the install
process
07/11/2008 12:21:42.875 Product Enumeration Results:
07/11/2008 12:21:42.890 INF File Name:
c:\0182380578d681c4efcd\HotFixExpress.inf
07/11/2008 12:21:42.890 baselinebuild = 1399
07/11/2008 12:21:42.890 build = 3042
07/11/2008 12:21:42.890 description = Express Database Services
07/11/2008 12:21:42.890 details = Service Pack for the SQL Server database
engine, and the tools for managing relational and XML data, Replication, and
Full-Text Search.
07/11/2008 12:21:42.890 installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Hotfix
07/11/2008 12:21:42.890 kbarticle = KB921896
07/11/2008 12:21:42.890 kbarticlehyperlink =
http://support.microsoft.com/?kbid=921896
07/11/2008 12:21:42.890 lcid = 1033
07/11/2008 12:21:42.890 legalproductname = SQL Server Express Database
Services 2005
07/11/2008 12:21:42.890 machinetype = x86
07/11/2008 12:21:42.890 package = HotFixExpress
07/11/2008 12:21:42.890 packagetype = SP
07/11/2008 12:21:42.890 productname = SQL9Express
07/11/2008 12:21:42.890 relatedlinks =
<LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
07/11/2008 12:21:42.890 servicepackname = Microsoft SQL Server 2005
Service Pack 2 Setup
07/11/2008 12:21:42.890 sku = EXPRESS
07/11/2008 12:21:42.890 splevel = 2
07/11/2008 12:21:42.906 sqlutility = sqlcmd.exe
07/11/2008 12:21:42.906 supportdir = c:\0182380578d681c4efcd
07/11/2008 12:21:42.906 validateauthentication = true
07/11/2008 12:21:42.906 version = 9
07/11/2008 12:21:42.906
07/11/2008 12:21:42.906 File Group Details: EXE
07/11/2008 12:21:42.906 parameters = INSTANCENAME=<NAME>
07/11/2008 12:21:42.906 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
07/11/2008 12:21:42.906 File Details: SQLEXPR.EXE
07/11/2008 12:21:42.906
07/11/2008 12:21:42.906 Instance Details: MSSMLBIZ
07/11/2008 12:21:42.906 associatedhotfixbuild = 0
07/11/2008 12:21:42.906 clustername =
07/11/2008 12:21:42.906 features =
SQL_Data_Files,SQL_Engine,SQL_SharedTools
07/11/2008 12:21:42.906 fullversion = 2005.090.2047.00
07/11/2008 12:21:42.906 hiveregpath = Software\Microsoft\Microsoft SQL
Server\MSSQL.1
07/11/2008 12:21:42.906 id = MSSQL.1
07/11/2008 12:21:42.921 installsqldatadir = c:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL
07/11/2008 12:21:42.921 installsqldir = c:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL
07/11/2008 12:21:42.921 lcid = 1033
07/11/2008 12:21:42.921 name = MSSMLBIZ
07/11/2008 12:21:42.921 productcode =
{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
07/11/2008 12:21:42.921 qfelevel = 2047
07/11/2008 12:21:42.921 servicename = MSSQL$MSSMLBIZ
07/11/2008 12:21:42.921 sku = EXPRESS
07/11/2008 12:21:42.921 sp = 1
07/11/2008 12:21:42.921 type = SQL Server Standalone Product
07/11/2008 12:21:42.921 vermajbld = 2047
07/11/2008 12:21:42.921 version = 9
07/11/2008 12:21:42.921
07/11/2008 12:21:42.968 Authenticating user using Windows Authentication
07/11/2008 12:21:42.968 SQL Service MSSQL$MSSMLBIZ was not previously
running, started for authentication
07/11/2008 12:21:42.984 Starting service: MSSQL$MSSMLBIZ
07/11/2008 12:21:48.750 Unable to start service: MSSQL$MSSMLBIZ
07/11/2008 12:21:48.765 The following exception occurred: Unable to start
service Date: 07/11/2008 12:21:48.765 File:
\depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\service.cpp Line: 318
07/11/2008 12:21:48.765 The following exception occurred: Unable to start
service Date: 07/11/2008 12:21:48.765 File:
\depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\control.cpp Line:
2509
07/11/2008 12:21:48.765 The patch installation could not proceed due to
unexpected errors
07/11/2008 12:21:49.953 Watson: Param1 = Unknown
07/11/2008 12:21:49.953 Watson: Param2 = 0x2b22
07/11/2008 12:21:49.953 Watson: Param3 = Unknown
07/11/2008 12:21:49.953 Watson: Param4 = Unknown
07/11/2008 12:21:49.953 Watson: Param5 = control.cpp@2509
07/11/2008 12:21:49.953 Watson: Param6 = Unknown
07/11/2008 12:21:49.968 Watson: Param7 = SQL9Express
07/11/2008 12:21:49.968 Watson: Param8 = @
07/11/2008 12:21:49.968 Watson: Param9 = x86
07/11/2008 12:21:49.968 Watson: Param10 = 3042


"Peter Saddow [Microsoft]" wrote:

> Looks like you have SQL Server 2005 Express Edition installed.
>
> Could you post the contents of the summary.txt log located at C:\Program
> Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We can then debug
> the issue.
>
> Thanks,
> Peter Saddow [MSFT]
>
>
> "DavidW" wrote:
>
> > This is listed as an Important Update:
> >
> > Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
> >
> > Download size: 56.4 MB
> >
> > You may need to restart your computer for this update to take effect.
> >
> > Update type: Important
> >
> > This service pack upgrades all Microsoft SQL Server 2005 Express Edition
> > instances and components to Service Pack 2 (SP2). If you need additional
> > installation options, you should download this service pack at the Microsoft
> > Download Center. For more information, see Microsoft Knowledge Base article
> > 921896.
> >
> > I tried to install and this is the error I get: WindowsUpdate_00002B33
> >
> > What should I do? Is it truly an Important update and if so, how do I
> > install it?
> >

[Massimo Nannizzi]

Dear Peter,
my Windows XP Professional service pack 2 ask to upgrade to Microsoft SQL
Server 2005 Express Edition al Service Pack 2 (SP2) but the installation
don't finish rigth because a message error showing.
This is the HotFix.log file:
12/23/2008 13:46:28.140
================================================================================
12/23/2008 13:46:28.171 Hotfix package launched
12/23/2008 13:46:28.218 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
12/23/2008 13:46:28.234 Registry: Read registry key value "CommonFilesDir",
string value = C:\Programmi\File comuni
12/23/2008 13:46:28.265 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
12/23/2008 13:46:28.312 Registry: Read registry key value "ProgramFilesDir",
string value = C:\Programmi
12/23/2008 13:46:28.328 Local Computer:
12/23/2008 13:46:28.343 Target Details: NANNIZZI
12/23/2008 13:46:28.375 commonfilesdir = C:\Programmi\File comuni
12/23/2008 13:46:28.406 lcidsupportdir =
c:\8f6c10b9606fc4791c08a78067f54575\1040
12/23/2008 13:46:28.421 programfilesdir = C:\Programmi
12/23/2008 13:46:28.453 programfilesdir_wow = C:\Programmi
12/23/2008 13:46:28.468 supportdir = c:\8f6c10b9606fc4791c08a78067f54575
12/23/2008 13:46:28.500 supportdirlocal =
c:\8f6c10b9606fc4791c08a78067f54575
12/23/2008 13:46:28.531 windir = C:\WINDOWS
12/23/2008 13:46:28.546 winsysdir = C:\WINDOWS\system32
12/23/2008 13:46:28.578 winsysdir_wow = C:\WINDOWS\SysWOW64
12/23/2008 13:46:28.593
12/23/2008 13:46:28.625 Enumerating applicable products for this patch
12/23/2008 13:46:28.640 Found SQL 2005 Express product definition
12/23/2008 13:46:29.281 Enumeration: Determining QFE level for product
instance MSSMLBIZ
12/23/2008 13:46:29.328 Enumeration: Associated hotfix build information not
found for the following file: C:\Programmi\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
12/23/2008 13:46:29.343 Enumeration: Found following QFE level for product
instance MSSMLBIZ: 2047
12/23/2008 13:46:29.375 Enumeration: Determining GDR branching Hotfix for
product instance MSSMLBIZ
12/23/2008 13:46:29.406 Enumeration: Associated hotfix build information not
found for the following file: C:\Programmi\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
12/23/2008 13:46:29.437 Enumeration: No GDR branch Hotfix found for product
instance MSSMLBIZ
12/23/2008 13:46:29.453 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
12/23/2008 13:46:29.484 Registry: Read registry key value "CommonFilesDir",
string value = C:\Programmi\File comuni
12/23/2008 13:46:29.515 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
12/23/2008 13:46:29.531 Registry: Read registry key value "ProgramFilesDir",
string value = C:\Programmi
12/23/2008 13:46:29.546 Product discovery completed during the install
process for MSSMLBIZ
12/23/2008 13:46:29.578 SP Level check completed during the install process
for MSSMLBIZ
12/23/2008 13:46:29.593 Product language check completed during the install
process for MSSMLBIZ
12/23/2008 13:46:29.625 Product version check completed during the install
process for MSSMLBIZ
12/23/2008 13:46:29.656 Command-line instance name check completed during
the install process
12/23/2008 13:46:29.703 SKU check completed during the install process for
MSSMLBIZ
12/23/2008 13:46:29.734 Baseline build check completed during the
installation process for MSSMLBIZ
12/23/2008 13:46:29.750 Baseline build check completed during the install
process
12/23/2008 13:46:29.796 Product Enumeration Results:
12/23/2008 13:46:29.843 INF File Name:
c:\8f6c10b9606fc4791c08a78067f54575\HotFixExpress.inf
12/23/2008 13:46:29.859 baselinebuild = 1399
12/23/2008 13:46:29.890 build = 3042
12/23/2008 13:46:29.921 description = Express Database Services
12/23/2008 13:46:29.937 details = Service Pack per il Motore di database
di SQL Server e gli strumenti per la gestione dei dati relazionali e XML,
della replica e della ricerca full-text.
12/23/2008 13:46:29.968 installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Hotfix
12/23/2008 13:46:29.984 kbarticle = KB921896
12/23/2008 13:46:30.015 kbarticlehyperlink =
http://support.microsoft.com/?kbid=921896
12/23/2008 13:46:30.046 lcid = 1040
12/23/2008 13:46:30.062 legalproductname = SQL Server Express Database
Services 2005
12/23/2008 13:46:30.078 machinetype = x86
12/23/2008 13:46:30.109 package = HotFixExpress
12/23/2008 13:46:30.125 packagetype = SP
12/23/2008 13:46:30.156 productname = SQL9Express
12/23/2008 13:46:30.187 relatedlinks =
<LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
12/23/2008 13:46:30.203 servicepackname = Installazione di Microsoft SQL
Server 2005 Service Pack 2
12/23/2008 13:46:30.234 sku = EXPRESS
12/23/2008 13:46:30.250 splevel = 2
12/23/2008 13:46:30.265 sqlutility = sqlcmd.exe
12/23/2008 13:46:30.312 supportdir = c:\8f6c10b9606fc4791c08a78067f54575
12/23/2008 13:46:30.328 validateauthentication = true
12/23/2008 13:46:30.343 version = 9
12/23/2008 13:46:30.375
12/23/2008 13:46:30.390 File Group Details: EXE
12/23/2008 13:46:30.421 parameters = INSTANCENAME=<NAME>
12/23/2008 13:46:30.453 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
12/23/2008 13:46:30.468 File Details: SQLEXPR_ITA.EXE
12/23/2008 13:46:30.500
12/23/2008 13:46:30.515 Instance Details: MSSMLBIZ
12/23/2008 13:46:30.531 associatedhotfixbuild = 0
12/23/2008 13:46:30.578 clustername =
12/23/2008 13:46:30.593 features =
SQL_Data_Files,SQL_Engine,SQL_SharedTools
12/23/2008 13:46:30.609 fullversion = 2005.090.2047.00
12/23/2008 13:46:30.640 hiveregpath = Software\Microsoft\Microsoft SQL
Server\MSSQL.1
12/23/2008 13:46:30.687 id = MSSQL.1
12/23/2008 13:46:30.718 installsqldatadir = C:\Programmi\Microsoft SQL
Server\MSSQL.1\MSSQL
12/23/2008 13:46:30.734 installsqldir = C:\Programmi\Microsoft SQL
Server\MSSQL.1\MSSQL
12/23/2008 13:46:30.765 lcid = 1040
12/23/2008 13:46:30.781 name = MSSMLBIZ
12/23/2008 13:46:30.828 productcode =
{4D2D9016-70A9-4D91-9AA7-686ACAF056D9}
12/23/2008 13:46:30.843 qfelevel = 2047
12/23/2008 13:46:30.890 servicename = MSSQL$MSSMLBIZ
12/23/2008 13:46:30.906 sku = EXPRESS
12/23/2008 13:46:30.921 sp = 1
12/23/2008 13:46:30.953 type = SQL Server Standalone Product
12/23/2008 13:46:30.968 vermajbld = 2047
12/23/2008 13:46:31.000 version = 9
12/23/2008 13:46:31.031
12/23/2008 13:46:31.046 Authenticating user using Windows Authentication
12/23/2008 13:46:33.640 SQL Service MSSQL$MSSMLBIZ was not previously
running, started for authentication
12/23/2008 13:46:33.687 Starting service: MSSQL$MSSMLBIZ
12/23/2008 13:46:40.500 Unable to start service: MSSQL$MSSMLBIZ
12/23/2008 13:46:40.578 The following exception occurred: Impossibile
avviare il servizio Date: 12/23/2008 13:46:40.562 File:
\depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\service.cpp Line: 318
12/23/2008 13:46:40.625 The following exception occurred: Impossibile
avviare il servizio Date: 12/23/2008 13:46:40.625 File:
\depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\control.cpp Line:
2509
12/23/2008 13:46:40.687 The patch installation could not proceed due to
unexpected errors
12/23/2008 13:46:43.968 Watson: Param1 = Unknown
12/23/2008 13:46:44.000 Watson: Param2 = 0x2b22
12/23/2008 13:46:44.015 Watson: Param3 = Unknown
12/23/2008 13:46:44.031 Watson: Param4 = Unknown
12/23/2008 13:46:44.062 Watson: Param5 = control.cpp@2509
12/23/2008 13:46:44.078 Watson: Param6 = Unknown
12/23/2008 13:46:44.109 Watson: Param7 = SQL9Express
12/23/2008 13:46:44.156 Watson: Param8 = @
12/23/2008 13:46:44.187 Watson: Param9 = x86
12/23/2008 13:46:44.203 Watson: Param10 = 3042

Can you help me?

Regards and merry Christmas.

"Peter Saddow [Microsoft]" wrote:

> Looks like the Express service is disabled. The service needs to be startable
> for the upgrade to complete. Go to Administrate Tools and then Services. Look
> for the entry called "SQL Server (ACT7)". Right-click on the entry and choose
> properties. You should see the "Startup Type" is disabled. Change the
> "Startup Type" to manual. Rerun the installation through Microsoft Update.
>
> "DavidW" wrote:
>
> > Sure thing:
> >
> > Time: 03/07/2007 18:51:52.227
> > KB Number: KB921896
> > Machine: DAVID2
> > OS Version: Professional (Build 6000)
> > 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
> > Express Database Services (SQLExpress) ENU SP1
> > x86 EXPRESS
> >
> > **********************************************************************************
> > Products Disqualified & Reason
> > Product Reason
> > Express Database Services (ACT7) Service was found to be disabled
> >
> > **********************************************************************************
> > 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 : Not Applied
> > Log File :
> > SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
> > Error Number : 11059
> > Error Description : Service was found to be disabled
> > ----------------------------------------------------------------------------------
> > Product : Express Database Services (SQLExpress)
> > Product Version (Previous):
> > Product Version (Final) :
> > Status : Not Applied
> > Log File :
> > SQL Express Features : Client_Components,Connectivity
> > Error Number : 0
> > Error Description :
> > ----------------------------------------------------------------------------------
> >
> > **********************************************************************************
> > Summary
> > Service was found to be disabled
> > Exit Code Returned: 11059
> >
> >
> >
> >
> > "Peter Saddow [Microsoft]" wrote:
> >
> > > Looks like you have SQL Server 2005 Express Edition installed.
> > >
> > > Could you post the contents of the summary.txt log located at C:\Program
> > > Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix? We can then debug
> > > the issue.
> > >
> > > Thanks,
> > > Peter Saddow [MSFT]
> > >
> > >
> > > "DavidW" wrote:
> > >
> > > > This is listed as an Important Update:
> > > >
> > > > Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
> > > >
> > > > Download size: 56.4 MB
> > > >
> > > > You may need to restart your computer for this update to take effect.
> > > >
> > > > Update type: Important
> > > >
> > > > This service pack upgrades all Microsoft SQL Server 2005 Express Edition
> > > > instances and components to Service Pack 2 (SP2). If you need additional
> > > > installation options, you should download this service pack at the Microsoft
> > > > Download Center. For more information, see Microsoft Knowledge Base article
> > > > 921896.
> > > >
> > > > I tried to install and this is the error I get: WindowsUpdate_00002B33
> > > >
> > > > What should I do? Is it truly an Important update and if so, how do I
> > > > install it?
> > > >