SQL Express 2005 Installation Fails On All Of Our PCs

The installation fails and crashes with "Error 110", while attempting to install the SQL Native Client... then crashes (DrWatson). This happens on every OS and test machines that we have within our company... flavors of W2K and WXP, all with .Net Framework 2.0.

If the SQL Native Client exists, the installation continues without error. If SQLEXPR32.EXE is run directly from the command line, the installation will succeed.

If SQLEXPR32.EXE is called from a Windows Installer Custom Action type 50, it will always fail. This is the method we used to successfully install MSDE previously.

Our command line is:

/qb ADDLOCAL=SQL_Engine,SQL_Data_Files SAPWD=password1 SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=2 INSTANCENAME=Instance SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 ENABLERANU=0

The problem appears to start with: Error: Action "ComponentUpdateAction" threw an exception during execution.

-----------------------------------------------

SQLSetup0009_Core.log

Microsoft SQL Server 2005 Setup beginning at Thu Mar 01 08:07:09 2007
Process ID : 852
c:57774bfc862c706a2e923076f41d037csetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/2/1 8:7:9
Complete: LoadResourcesAction at: 2007/2/1 8:7:9, returned true
Running: ParseBootstrapOptionsAction at: 2007/2/1 8:7:9
Loaded DLL:c:57774bfc862c706a2e923076f41d037cxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/2/1 8:7:9, returned true
Running: ValidateWinNTAction at: 2007/2/1 8:7:9
Complete: ValidateWinNTAction at: 2007/2/1 8:7:9, returned true
Running: ValidateMinOSAction at: 2007/2/1 8:7:9
Complete: ValidateMinOSAction at: 2007/2/1 8:7:9, returned true
Running: PerformSCCAction at: 2007/2/1 8:7:9
Complete: PerformSCCAction at: 2007/2/1 8:7:9, returned true
Running: ActivateLoggingAction at: 2007/2/1 8:7:9
Complete: ActivateLoggingAction at: 2007/2/1 8:7:9, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__852" returned false.
Running: PerformSCCAction2 at: 2007/2/1 8:7:9
Complete: PerformSCCAction2 at: 2007/2/1 8:7:9, returned true
Running: PerformDotNetCheck at: 2007/2/1 8:7:9
Complete: PerformDotNetCheck at: 2007/2/1 8:7:9, returned true
Running: ComponentUpdateAction at: 2007/2/1 8:7:9
Error: Action "ComponentUpdateAction" threw an exception during execution. Error information reported during run:
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='SnacComp::Init'>
<Func Name='SnacComp::IsRequired'>
SNAC version installing: 9.00.3042.00
The installed SNAC version is less then the installing version
SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:506}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
<Func Name='SnacComp::InstallImp'>
Failed to install SNAC
Failed to install SNAC : (110) {e:sql9_sp2_tsqlsetupsqlcudllsnaccomp.cpp:251}
SCU_SetupMgr::svc() caught exception: Failed to install SNAC : (110) {e:sql9_sp2_tsqlsetupsqlcudllsnaccomp.cpp:251}. SetupMgr: state=ERROR, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:520}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
<EndFunc Name='UpdateComponents' Return='1603' GetLastError='87'>
Component update returned a fatal error : 110
Error Code: 0x8007006e (110)
Windows Error Text: The system cannot open the device or file specified.

Source File Name: sqlncli.msi
Compiler Timestamp: Thu Oct 5 12:22:33 2006
Function Name: Unknown
Source Line Number: 1583

Class not registered.



--------------------------------------------

SQLSetup0009_SNAC.log

=== Verbose logging started: 3/1/2007 8:07:10 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:WINDOWSsystem32msiexec.exe ===
MSI (c) (FC:C8) [08:07:10:062]: Resetting cached policy values
MSI (c) (FC:C8) [08:07:10:062]: Machine policy value 'Debug' is 0
MSI (c) (FC:C8) [08:07:10:062]: ******* RunEngine:
******* Product: c:57774bfc862c706a2e923076f41d037csetupsqlncli.msi
******* Action:
******* CommandLine: **********
MSI (c) (FC:C8) [08:07:10:062]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (FC:C8) [08:07:10:062]: Grabbed execution mutex.
MSI (c) (FC:C8) [08:07:10:109]: Cloaking enabled.
MSI (c) (FC:C8) [08:07:10:109]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (FC:C8) [08:07:10:125]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (30:5C) [08:07:10:140]: Grabbed execution mutex.
MSI (s) (30:B0) [08:07:10:140]: Resetting cached policy values
MSI (s) (30:B0) [08:07:10:140]: Machine policy value 'Debug' is 0
MSI (s) (30:B0) [08:07:10:140]: ******* RunEngine:
******* Product: c:57774bfc862c706a2e923076f41d037csetupsqlncli.msi
******* Action:
******* CommandLine: **********
MSI (s) (30:B0) [08:07:10:156]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (30:B0) [08:07:10:171]: Note: 1: 1309 2: 5 3: C:57774bfc862c706a2e923076f41d037csetupsqlncli.msi
MSI (s) (30:B0) [08:07:10:171]: MainEngineThread is returning 110
The system cannot open the device or file specified.
MSI (c) (FC:C8) [08:07:10:171]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (FC:C8) [08:07:10:171]: MainEngineThread is returning 110
=== Verbose logging stopped: 3/1/2007 8:07:10 ===