SQL Express Install fails Error 29503 / 1067


i have read numerous previous posts on similar errors.  far i've ruled out:


1. have athlon processor cache prefetching xp 1700+
2. have tried installing advanced options , selecting local sytem , local service.
none of these solutions solved problem.  still same install error , it's quite maddening, since install program verifies of hardware , software meet install conditions.  running xp home, i'm in workgroup, not domain..  attach log install below.

any more suggestions?
thanks,
gtc.

microsoft sql server 2005 9.00.2047.00

==============================

os version      : microsoft windows xp home edition service pack 2 (build 2600)

time            : thu sep 14 19:48:26 2006

 

machine         : thomas

product         : microsoft sql server setup support files (english)

product version : 9.00.2047.00

install         : successful

log file        : c:\program files\microsoft sql server\90\setup bootstrap\log\files\sqlsetup0006_thomas_sqlsupport_1.log

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

machine         : thomas

product         : microsoft sql server native client

product version : 9.00.2047.00

install         : successful

log file        : c:\program files\microsoft sql server\90\setup bootstrap\log\files\sqlsetup0006_thomas_sqlncli_1.log

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

machine         : thomas

product         : microsoft sql server vss writer

product version : 9.00.2047.00

install         : successful

log file        : c:\program files\microsoft sql server\90\setup bootstrap\log\files\sqlsetup0006_thomas_sqlwriter_1.log

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

machine         : thomas

product         : msxml 6.0 parser

product version : 6.00.3883.8

install         : successful

log file        : c:\program files\microsoft sql server\90\setup bootstrap\log\files\sqlsetup0006_thomas_msxml6_1.log

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

machine         : thomas

product         : microsoft sql server setup support files (english)

product version : 9.00.2047.00

install         : successful

log file        : c:\program files\microsoft sql server\90\setup bootstrap\log\files\sqlsetup0006_thomas_sqlsupport_2.log

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

machine         : thomas

product         : microsoft sql server native client

product version : 9.00.2047.00

install         : successful

log file        : c:\program files\microsoft sql server\90\setup bootstrap\log\files\sqlsetup0006_thomas_sqlncli_2.log

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

machine         : thomas

product         : msxml 6.0 parser

product version : 6.00.3883.8

install         : successful

log file        : c:\program files\microsoft sql server\90\setup bootstrap\log\files\sqlsetup0006_thomas_msxml6_2.log

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

machine         : thomas

product         : sql server database services

error           : sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."

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

machine         : thomas

product         : microsoft sql server 2005 express edition

product version : 9.1.2047.00

install         : failed

log file        : c:\program files\microsoft sql server\90\setup bootstrap\log\files\sqlsetup0006_thomas_sql.log

last action     : installfinalize

error string    : sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."

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

---- context -----------------------------------------------


setting status of unmanaged components , removing unmanaged resources
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress



error code: 1067
msi (s) (54!e8) [19:55:22:056]: product: microsoft sql server 2005 express edition -- error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.

error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.
<func name='getcacontext'>
<endfunc name='getcacontext' return='t' getlasterror='203'>
doing action: do_sqlscript
perftime start: do_sqlscript : thu sep 14 19:55:22 2006
service mssql$sqlexpress parameters '-m sqlsetup -q -qsql_latin1_general_cp1_ci_as -t4022 -t3659 -t3610 -t4010' being started @ thu sep 14 19:55:22 2006
service failed unexpectedly (1067)
        error code: 0x8007042b (1067)
windows error text: process terminated unexpectedly.
  source file name: sqlsetuplib\service.cpp
compiler timestamp: wed oct 26 16:37:52 2005
     function name: sqls::service::start
source line number: 301



---- context -----------------------------------------------


setting status of unmanaged components , removing unmanaged resources
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress



error code: 1067
msi (s) (54!e8) [19:55:27:674]: product: microsoft sql server 2005 express edition -- error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.

error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.
<func name='getcacontext'>
<endfunc name='getcacontext' return='t' getlasterror='203'>
doing action: do_sqlscript
perftime start: do_sqlscript : thu sep 14 19:55:27 2006
service mssql$sqlexpress parameters '-m sqlsetup -q -qsql_latin1_general_cp1_ci_as -t4022 -t3659 -t3610 -t4010' being started @ thu sep 14 19:55:27 2006
service failed unexpectedly (1067)
        error code: 0x8007042b (1067)
windows error text: process terminated unexpectedly.
  source file name: sqlsetuplib\service.cpp
compiler timestamp: wed oct 26 16:37:52 2005
     function name: sqls::service::start
source line number: 301



---- context -----------------------------------------------


setting status of unmanaged components , removing unmanaged resources
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress



error code: 1067
msi (s) (54!e8) [19:55:50:927]: product: microsoft sql server 2005 express edition -- error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.

error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.
<func name='getcacontext'>
<endfunc name='getcacontext' return='t' getlasterror='203'>
doing action: do_sqlscript
perftime start: do_sqlscript : thu sep 14 19:55:50 2006
service mssql$sqlexpress parameters '-m sqlsetup -q -qsql_latin1_general_cp1_ci_as -t4022 -t3659 -t3610 -t4010' being started @ thu sep 14 19:55:50 2006
service failed unexpectedly (1067)
        error code: 0x8007042b (1067)
windows error text: process terminated unexpectedly.
  source file name: sqlsetuplib\service.cpp
compiler timestamp: wed oct 26 16:37:52 2005
     function name: sqls::service::start
source line number: 301



---- context -----------------------------------------------


setting status of unmanaged components , removing unmanaged resources
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress



error code: 1067
msi (s) (54!e8) [19:55:55:013]: product: microsoft sql server 2005 express edition -- error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.

error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.
<func name='getcacontext'>
<endfunc name='getcacontext' return='t' getlasterror='203'>
doing action: do_sqlscript
perftime start: do_sqlscript : thu sep 14 19:55:55 2006
service mssql$sqlexpress parameters '-m sqlsetup -q -qsql_latin1_general_cp1_ci_as -t4022 -t3659 -t3610 -t4010' being started @ thu sep 14 19:55:55 2006
service failed unexpectedly (1067)
        error code: 0x8007042b (1067)
windows error text: process terminated unexpectedly.
  source file name: sqlsetuplib\service.cpp
compiler timestamp: wed oct 26 16:37:52 2005
     function name: sqls::service::start
source line number: 301



---- context -----------------------------------------------


setting status of unmanaged components , removing unmanaged resources
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress



error code: 1067
msi (s) (54!e8) [19:55:58:078]: product: microsoft sql server 2005 express edition -- error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.

error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.
<func name='getcacontext'>
<endfunc name='getcacontext' return='t' getlasterror='203'>
doing action: do_sqlscript
perftime start: do_sqlscript : thu sep 14 19:55:58 2006
service mssql$sqlexpress parameters '-m sqlsetup -q -qsql_latin1_general_cp1_ci_as -t4022 -t3659 -t3610 -t4010' being started @ thu sep 14 19:55:58 2006
service failed unexpectedly (1067)
        error code: 0x8007042b (1067)
windows error text: process terminated unexpectedly.
  source file name: sqlsetuplib\service.cpp
compiler timestamp: wed oct 26 16:37:52 2005
     function name: sqls::service::start
source line number: 301



---- context -----------------------------------------------


setting status of unmanaged components , removing unmanaged resources
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress



error code: 1067
msi (s) (54!e8) [19:57:11:203]: product: microsoft sql server 2005 express edition -- error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.

error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.
<func name='getcacontext'>
<endfunc name='getcacontext' return='t' getlasterror='203'>
doing action: do_sqlscript
perftime start: do_sqlscript : thu sep 14 19:57:11 2006
service mssql$sqlexpress parameters '-m sqlsetup -q -qsql_latin1_general_cp1_ci_as -t4022 -t3659 -t3610 -t4010' being started @ thu sep 14 19:57:11 2006
service failed unexpectedly (1067)
        error code: 0x8007042b (1067)
windows error text: process terminated unexpectedly.
  source file name: sqlsetuplib\service.cpp
compiler timestamp: wed oct 26 16:37:52 2005
     function name: sqls::service::start
source line number: 301



---- context -----------------------------------------------


setting status of unmanaged components , removing unmanaged resources
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress
do_sqlscript
sqlscripthlpr
start service mssql$sqlexpress



error code: 1067
msi (s) (54!e8) [19:57:14:878]: product: microsoft sql server 2005 express edition -- error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.

error 29503. sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually."
the error is  (1067) process terminated unexpectedly.
.
<failure type='fatal' error='1067'>
<endfunc name='launchfunction' return='1067' getlasterror='203'>
msi (s) (54:64) [19:57:14:978]: user policy value 'disablerollback' 0
msi (s) (54:64) [19:57:14:978]: machine policy value 'disablerollback' 0
action ended 19:57:14: installfinalize. return value 3.

a helpful tech @ microsoft connect solved problem.  posting copy of solution here.  see microsoft connect forum sql express more details.  note machine part of workgroup , not belong domain.  tried install sql express using "advanced options," suggested in other posts, still inadequate solve problem.  regedit required...

 

>most "domain" missing following windows registry >hkey_loocal_machine\system\currentcontrolset\services\tcpip\parameters 

>i assume rmachine not joined domain. if that's case, can try creating empty reg_sz value named >"domain" in hkey_local_machine\system\currentcontrolset\services\tcpip\parameters of registry.

>you can follow these steps: (1) open regedit (start|run, type regedit). (2) navigate >hkey_local_machine\system\currentcontrolset\services\tcpip\parameters. (3) right-click parameters. (4) >choose new->string value. (5) type domain name of new value, , hit enter. (6) rerun sql server >setup. please, let know if helped.

>*warning* serious problems might occur if modify registry incorrectly using registry editor or using >method. these problems might require reinstall operating system. microsoft cannot guarantee these >problems can solved. modify registry @ own risk.

 



SQL Server  >  SQL Server Setup & Upgrade



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........