SQL Server 2005 Express Ed (KB 921896): errorcode 0x65B
JoVL
Can anyone help? The automatic update of my MS SQL Server 2005 Express
Edition (KB 921896) keeps on failing, giving errorcode 0x65B.
The log file summary.txt at C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix looks like (in double Dutch):
Time: 03/17/2007 16:15:56.984
KB Number: KB921896
Machine: ABC
OS Version: Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Package Language: 1043 (NLA)
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 (SQLEXPRESS) NLD SP1 2005.090.2047.00
x86 EXPRESS
Express Database Services (SQLExpress) NLD SP2
x86 EXPRESS
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name
PID
**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 2047
Product Version (Final) :
Status : Fout
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_NLA.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 1627
Error Description : Kan het MSI-bestand van Windows Installer niet
installeren
----------------------------------------------------------------------------------
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) : 3042
Status : Voltooid
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_NLA.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1627
PeterSadd
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_NLA.EXE", there
should be one of more log files. Can you search these log files for the
"value 3". If you find "value 3", please copy/paste the 20 lines above to
the newsgroup.
Thanks,
Peter Saddow - Microsoft
"JoVL" <Jo...@discussions.microsoft.com> wrote in message
news:B2EA08AB-E0C3-435E...@microsoft.com...
JoVL
This excerpt comes from Hotfix.txt. I couldn't find any "value 3" in any
file in the Hotfix directory and below.
03/17/2007 18:24:56.562
================================================================================
03/17/2007 18:24:56.640 Hotfix package launched
03/17/2007 18:24:56.765 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
03/17/2007 18:24:56.765 Registry: Read registry key value "CommonFilesDir",
string value = C:\Program Files\Common Files
03/17/2007 18:24:56.843 Registry: Opened registry key
"SOFTWARE\Microsoft\Windows\CurrentVersion"
03/17/2007 18:24:56.890 Registry: Read registry key value "ProgramFilesDir",
string value = C:\Program Files
03/17/2007 18:24:56.953 Local Computer:
...
03/17/2007 18:25:02.562 Product discovery completed during the install
process for SQLExpress
03/17/2007 18:25:02.609 SP Level check completed during the install process
for SQLExpress
03/17/2007 18:25:02.671 Product language check completed during the install
process for SQLExpress
03/17/2007 18:25:02.703 Product version check completed during the install
process for SQLExpress
03/17/2007 18:25:02.750 Command-line instance name check completed during
the install process
03/17/2007 18:25:02.781 SKU check completed during the install process for
SQLEXPRESS
03/17/2007 18:25:02.812 SKU check completed during the install process for
SQLExpress
03/17/2007 18:25:02.843 Baseline build check completed during the
installation process for SQLEXPRESS
03/17/2007 18:25:02.921 Baseline build check completed during the
installation process for SQLExpress
03/17/2007 18:25:02.968 Baseline build check completed during the install
process
03/17/2007 18:25:03.015 Product Enumeration Results:
...
03/17/2007 18:25:12.093 Installing product: SQL9Express
03/17/2007 18:25:12.515 Installing instance: SQLEXPRESS
03/17/2007 18:25:12.890 Installing target: ABC
03/17/2007 18:25:12.984 Validating database connections using Windows
Authentication
03/17/2007 18:25:13.671 Pre-script database connection check was successful
- proceeding with script execution
03/17/2007 18:25:17.593 Received list of RANU pid's
03/17/2007 18:25:17.750 Validating database connections using Windows
Authentication
03/17/2007 18:25:18.171 Pre-script database connection check was successful
- proceeding with script execution
03/17/2007 18:25:18.484 Stopping service: MSSQL$SQLEXPRESS
03/17/2007 18:25:27.593 Stopped service: MSSQL$SQLEXPRESS
03/17/2007 18:25:27.656 Installing file: SQLEXPR_NLA.EXE
03/17/2007 18:25:27.703 Copy Engine: Creating MSI install log file at:
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_NLA.EXE
03/17/2007 18:25:27.750 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer"
03/17/2007 18:25:27.781 Registry: Cannot read registry key value "Debug"
03/17/2007 18:30:08.015 EXE returned 1627: De functie is tijdens het
uitvoeren mislukt.
03/17/2007 18:30:08.062 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer"
03/17/2007 18:30:08.093 Registry: Cannot read registry key value "Debug"
03/17/2007 18:30:08.140 Copy Engine: Error, unable to install EXE file:
c:\46ffd1bb38efdb67e9fe80613f9267\HotFixExpress\Files\SQLEXPR_NLA.EXE
03/17/2007 18:30:08.171 The following exception occurred: Kan het
MSI-bestand van Windows Installer niet installeren Date: 03/17/2007
18:30:08.171 File:
\depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line:
1653
03/17/2007 18:30:18.281 Watson: Param1 = Unknown
03/17/2007 18:30:18.453 Watson: Param2 = 0x65b
03/17/2007 18:30:18.531 Watson: Param3 = Unknown
03/17/2007 18:30:18.578 Watson: Param4 = 0x65b
03/17/2007 18:30:18.656 Watson: Param5 = copyengine.cpp@1653
03/17/2007 18:30:18.750 Watson: Param6 = Unknown
03/17/2007 18:30:18.828 Watson: Param7 = SQL9Express
03/17/2007 18:30:18.890 Watson: Param8 = @
03/17/2007 18:30:18.937 Watson: Param9 = x86
03/17/2007 18:30:18.968 Watson: Param10 = 3042
03/17/2007 18:30:19.031 Installed product: SQL9Express
03/17/2007 18:30:19.109 Installing product: SQL9Express
03/17/2007 18:30:19.343 Installing instance: SQLExpress
03/17/2007 18:30:19.718 Installing target: ABC
03/17/2007 18:30:19.812 Installing file: SQLEXPR_NLA.EXE
03/17/2007 18:30:19.843 Copy Engine: Creating MSI install log file at:
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_NLA.EXE
03/17/2007 18:30:19.906 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer"
03/17/2007 18:30:20.031 Registry: Cannot read registry key value "Debug"
03/17/2007 18:32:12.171 EXE returned 0: De actie is voltooid.
03/17/2007 18:32:12.218 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer"
03/17/2007 18:32:12.281 Registry: Cannot read registry key value "Debug"
03/17/2007 18:32:12.375 Copy Engine: Installed file:
c:\46ffd1bb38efdb67e9fe80613f9267\HotFixExpress\Files\SQLEXPR_NLA.EXE
03/17/2007 18:32:12.515 Installed target: ABC
03/17/2007 18:32:16.515 Installed instance: SQLExpress
03/17/2007 18:32:16.609 Installed product: SQL9Express
03/17/2007 18:32:16.703 Hotfix package completed
03/17/2007 18:32:16.734 Attempting to continue the 32 bit ngen queue
Robert Aldwinckle
...
> This excerpt comes from Hotfix.txt.
> 03/17/2007 18:25:27.750 Registry: Opened registry key
> "Software\Policies\Microsoft\Windows\Installer"
> 03/17/2007 18:25:27.781 Registry: Cannot read registry key value "Debug"
> 03/17/2007 18:30:08.015 EXE returned 1627: De functie is tijdens het
> uitvoeren mislukt.
Calc confirms 0x65B == 1627
<cmd_output command="net helpmsg 1627"
Function failed during execution.
</cmd_output>
So that wasn't too informative. But perhaps the previous line is telling us
something? E.g. possible permissions problem with that key?
Try running ProcMon to find out?
Good luck
Robert Aldwinckle
---
Peter Saddow
%programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\hotfix
The error you are see in the hotfix.log likely is not the problem.
Thanks,
Peter Saddow - Microsoft
"Robert Aldwinckle" <rob...@techemail.com> wrote in message
news:%23ATXrO1...@TK2MSFTNGP05.phx.gbl...
meeok2
Product Installation Status
Product : Express Database Services (GOFIGURE)
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_Replication,SQL_SharedTools
Error Number : 1627
Error Description : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------
Jon Ley
SQL.log file:
-------------------------------------------------------
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to
accept client connections
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL
Native Client][SQL Server]Changed database context to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL
Native Client][SQL Server]Changed language setting to us_english.
<Func Name='SqlComponentUpgrade'>
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
<Func Name='ProcessHeaderTable'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
MSI (s) (F4!0C) [07:48:18:312]: Note: 1: 2259 2: 3: 4:
<Func Name='GetFileTargetPath'>
Error Code: 0x8007065b (1627)
Windows Error Text: Function failed during execution.
Source File Name: darlib\viewinstaller.cpp
Compiler Timestamp: Wed Jun 14 16:19:22 2006
Function Name: sqls::ViewInstaller::modify
Source Line Number: 137
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Failed to modify installer view
1: 2259 2: 3: 4:
Error Code: 1627
MSI (s) (F4!0C) [07:48:18:468]: Product: Microsoft SQL Server 2005 -- Error
2259. The installer has encountered an unexpected error. The error code is
2259. Database: Table(s) Update failed
Error 2259. The installer has encountered an unexpected error. The error
code is 2259. Database: Table(s) Update failed
<Failure Type='Fatal' Error='1627'>
<EndFunc Name='LaunchFunction' Return='1627' GetLastError='203'>
Action ended 07:48:18: ValidateUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2.
Return value 3.
Action ended 07:48:18: INSTALL. Return value 3.
-------------------------------------------------------------
Regards,
Jon.
JoVL
I'm sorry it took that long, I've been out of town.
You're absolutely right: the information in hotfix.log makes no sense, but
summary.txt included below does!
As far as I can understand, KB921896 can't connect to my SQLEXPRESS: I have
indeed "windows authentication" turned on (as recommended) instead of "SQL
and windows authentication". I can't imagine I'm the only one in this
situation, unless it has something to do with the fact that I'm running a
Dutch version.
Regards,
Jo
Time: 04/15/2007 08:24:45.703
KB Number: KB921896
Machine: ABC
OS Version: Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Package Language: 1043 (NLA)
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 (SQLEXPRESS) NLD SP1 2005.090.2047.00
x86 EXPRESS
Express Database Services (SQLExpress) NLD SP2
x86 EXPRESS
**********************************************************************************
Products Disqualified & Reason
Product Reason
Express Database Services (SQLEXPRESS) De gebruikersverificatie is
mislukt. Controleer of het opgegeven wachtwoord correct is of controleer of
de SQL Server-sessie is ingesteld op gemengde verificatie
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name
PID
**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 2047
Product Version (Final) :
Status : Niet toegepast
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 11046
Error Description : De gebruikersverificatie is mislukt. Controleer
of het opgegeven wachtwoord correct is of controleer of de SQL Server-sessie
is ingesteld op gemengde verificatie
----------------------------------------------------------------------------------
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) :
Status : Niet toegepast
Log File :
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
De gebruikersverificatie is mislukt. Controleer of het opgegeven
wachtwoord correct is of controleer of de SQL Server-sessie is ingesteld op
gemengde verificatie
Exit Code Returned: 11046
JoVL
Forget about my previous reply: that particular summary.txt was the 1 out of
12 exception.
From all 12 installion trials, it failed only once because of
authentication. I tried to install the update with "mixed authentication"
and it made no difference with the initial problem as stated in my first post.
Let's forget forget about this exception, and focus on my initial question,
carrying the original summary.txt.
Regards,
Jo
JoVL
That summary.txt is in my initial post, and says in essence:
"Error Number : 1627
Error Description : Can't install MSI-file from windows installer"
Regards,
Jo
LThibx
SQLSetupnnnn_machinename_SQL.log file wher the 1627 (65b) error occurs. Has
something to do with a failed table update.
Hope someone can decipher this and come up with a resolution.
-----------------------------------------------------------------------------------------------------------------------------------
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to
accept client connections
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL
Native Client][SQL Server]Changed database context to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL
Native Client][SQL Server]Changed language setting to us_english.
<Func Name='SqlComponentUpgrade'>
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
<Func Name='ProcessHeaderTable'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
MSI (s) (80!20) [03:03:32:065]: Note: 1: 2259 2: 3: 4:
<Func Name='GetFileTargetPath'>
Error Code: 0x8007065b (1627)
Windows Error Text: Function failed during execution.
Source File Name: darlib\viewinstaller.cpp
Compiler Timestamp: Wed Jun 14 16:19:22 2006
Function Name: sqls::ViewInstaller::modify
Source Line Number: 137
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Failed to modify installer view
1: 2259 2: 3: 4:
Error Code: 1627
MSI (s) (80!20) [03:03:32:128]: Product: Microsoft SQL Server 2005 Express
Edition -- Error 2259. The installer has encountered an unexpected error. The
error code is 2259. Database: Table(s) Update failed
Error 2259. The installer has encountered an unexpected error. The error
code is 2259. Database: Table(s) Update failed
<Failure Type='Fatal' Error='1627'>
<EndFunc Name='LaunchFunction' Return='1627' GetLastError='203'>
Action ended 3:03:32: ValidateUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2.
Return value 3.
Action ended 3:03:32: INSTALL. Return value 3.
----------------------------------------------------------------------------------------------------------------------------------
--
Thanks
LThibx
Alex
06/11/2007 07:43:32.078 SQL Service MSSQL$SQLEXPRESS was not previously
running, started for authentication
06/11/2007 07:43:32.078 Starting service: MSSQL$SQLEXPRESS
06/11/2007 07:43:37.328 Started service: MSSQL$SQLEXPRESS
06/11/2007 07:43:38.578 Stopping service: MSSQL$SQLEXPRESS
06/11/2007 07:43:40.578 Stopped service: MSSQL$SQLEXPRESS
06/11/2007 07:43:40.578 Registry: Opened registry key
"System\CurrentControlSet\Control\Session Manager"
06/11/2007 07:43:40.578 Registry: Cannot read registry key value
"PendingFileRenameOperations"
06/11/2007 07:43:40.578 Locked file: Checking for locked files
06/11/2007 07:43:40.593 Attempting to pause the 32 bit ngen queue
06/11/2007 07:43:41.328 Installing product: SQL9Express
06/11/2007 07:43:41.328 Installing instance: SQLEXPRESS
06/11/2007 07:43:41.343 Installing target: A
06/11/2007 07:43:41.359 Installing file: SQLEXPR_ADV.EXE
06/11/2007 07:43:41.375 Copy Engine: Creating MSI install log file at:
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_ADV.EXE
06/11/2007 07:43:41.375 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer"
06/11/2007 07:43:41.375 Registry: Cannot read registry key value "Debug"
06/11/2007 07:45:44.875 EXE returned 1627: The function failed during
execution.
06/11/2007 07:45:44.890 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer"
06/11/2007 07:45:44.906 Registry: Cannot read registry key value "Debug"
06/11/2007 07:45:44.906 Copy Engine: Error, unable to install EXE file:
c:\0b7eaf017ffb8ebaa5a87a09\HotFixExpressAdv\Files\SQLEXPR_ADV.EXE
06/11/2007 07:45:44.906 The following exception occurred: Unable to install
Windows Installer MSI file Date: 06/11/2007 07:45:44.906 File:
\depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line:
1653
06/11/2007 07:45:45.343 Watson: Param1 = Unknown
06/11/2007 07:45:45.359 Watson: Param2 = 0x65b
06/11/2007 07:45:45.375 Watson: Param3 = Unknown
06/11/2007 07:45:45.375 Watson: Param4 = 0x65b
06/11/2007 07:45:45.390 Watson: Param5 = copyengine.cpp@1653
06/11/2007 07:45:45.406 Watson: Param6 = Unknown
06/11/2007 07:45:45.406 Watson: Param7 = SQL9Express
06/11/2007 07:45:45.406 Watson: Param8 = @
06/11/2007 07:45:45.421 Watson: Param9 = x86
06/11/2007 07:45:45.421 Watson: Param10 = 3042
06/11/2007 07:45:45.421 Installed product: SQL9Express
06/11/2007 07:45:45.437 Hotfix package completed
06/11/2007 07:45:45.437 Attempting to continue the 32 bit ngen queue
tbarkdull
install CD.
--
tbark