msde 2000 sp4 - configuration failed

There is a bugfix in sp4 that I need for a customer machine. I have
been unsuccesful in getting service pack 4 installed on a test machine.
configuration:
windows 2000, msde 2000 sp2
setup command line:
setup /upgradesp sqlrun SECURITYMODE=SQL
UPGRADEUSER=myadminacct UPGRADEPWD=mypassword /L*v
C:\MSDELog.log
The setup runs for a couple minutes, then dialog progress bar winds
down. I have a 3.7 MB log, at the end I have:
=== Logging stopped: 7/7/2005 15:30:34 ===
MSI (c) (44:BC): Note: 1: 1729
MSI (c) (44:BC): Product: Microsoft SQL Server Desktop Engine --
Configuration failed.
MSI (c) (44:BC): Grabbed execution mutex.
MSI (c) (44:BC): Cleaning up uninstalled install packages, if
any exist
MSI (c) (44:BC): MainEngineThread is returning 1603
=== Verbose logging stopped: 7/7/2005 15:30:34 ===
After this happens, sqlserver agent will no longer start. I re-imaged
the machine and ran it again with the same result.
Anyone else have similar problems installing sp4? Anyone have a
solution?
Thanks!
hi,
slide@.backpacker.com wrote:
> === Logging stopped: 7/7/2005 15:30:34 ===
> MSI (c) (44:BC): Note: 1: 1729
> MSI (c) (44:BC): Product: Microsoft SQL Server Desktop Engine --
> Configuration failed.
> MSI (c) (44:BC): Grabbed execution mutex.
> MSI (c) (44:BC): Cleaning up uninstalled install packages, if
> any exist
> MSI (c) (44:BC): MainEngineThread is returning 1603
> === Verbose logging stopped: 7/7/2005 15:30:34 ===
please search for
RETURN VALUE 3
entries... about 10/15 lines before each entry you should find some
(sometime cryptic) description...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea, thanks for the response! I found a 3:
<first>
Starting custom action SetFileAndRegACLs()
Beginning modification of directory Security Descriptor (SD).
SQL Path: C:\Program Files\Microsoft SQL Server\MSSQL\\
SQL Data Path: C:\Program Files\Microsoft SQL Server\MSSQL\\
SQL Service Account: .\dbservice
Agent Service Account: .\dbservice
Error:
No mapping between account names and security IDs was done.
Error Code = 1332
Ending modification of directory Security Descriptor (SD).
Ending custom action SetFileAndRegACLs().
Action ended 15:30:03: InstallFinalize. Return value 3.
</first>
<second>
Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (14:20): Executing op: End(Checksum=0,ProgressTotal=0)
MSI (s) (14:20): Error in rollback skipped. Return: 5
MSI (s) (14:20): FEATURECACHE: Entering Invalidate
MSI (s) (14:20): Unlocking Server
Action ended 15:30:33: INSTALL. Return value 3.
</second>
This last one was right after a property dump after the second one:
<third>
MSI (s) (14:20): MainEngineThread is returning 1603
MSI (c) (44:BC): Back from server. Return value: 1603
MSI (c) (44:BC): Decrementing counter to disable shutdown. If counter
>= 0, shutdown will be denied. Counter after decrement: -1
Action ended 15:30:34: INSTALL. Return value 3.
</third>
Any ideas?
-Chris
Andrea Montanari wrote:
> hi,
> slide@.backpacker.com wrote:
> please search for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry you should find some
> (sometime cryptic) description...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
|||hi,
slide@.backpacker.com wrote:
> Andrea, thanks for the response! I found a 3:
> <first>
> Starting custom action SetFileAndRegACLs()
> Beginning modification of directory Security Descriptor (SD).
> SQL Path: C:\Program Files\Microsoft SQL Server\MSSQL\\
> SQL Data Path: C:\Program Files\Microsoft SQL Server\MSSQL\\
> SQL Service Account: .\dbservice
> Agent Service Account: .\dbservice
> Error:
> No mapping between account names and security IDs was done.
> Error Code = 1332
> Ending modification of directory Security Descriptor (SD).
> Ending custom action SetFileAndRegACLs().
> Action ended 15:30:03: InstallFinalize. Return value 3.
> </first>
unfortunately I only found information like http://tinyurl.com/cs39o , and
really do not know if can help... the answers are not very consistent, but
at the very end of the thread there's a note... perhaps...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> unfortunately I only found information like http://tinyurl.com/cs39o , and
> really do not know if can help... the answers are not very consistent, but
> at the very end of the thread there's a note... perhaps...
Thanks for the "value 3" tip. This was some problem with the account
that sqlserveragent and mssqlserver were running under. Changed to
LocalSystem and installation succeeded.