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\sql sedll\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\sql sedll\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?
> > > >
Linear Mode
