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.

MSDE 2000 SP3 Merge Module does not installing on windowx XP

Dear Sirs.
MSDE 2000 SP 3a Merge Module Does not installing on Windows XP Without XP
Service Pack.
It is work if SP1 is instaled on Windows XP. But how i can use that merge
modules if SP1 is not installed on Windows XP ?
Thank you in advance.
Install SP1 on Windows XP. You can generally do this if it's a legal copy.
"Irakli Lomidze" <Irakli_Lomidze@.access.sanet.ge> wrote in message
news:uzsiaVNuEHA.2196@.TK2MSFTNGP14.phx.gbl...
> Dear Sirs.
> MSDE 2000 SP 3a Merge Module Does not installing on Windows XP Without XP
> Service Pack.
> It is work if SP1 is instaled on Windows XP. But how i can use that merge
> modules if SP1 is not installed on Windows XP ?
> Thank you in advance.
>

MSDE (SQL 2000) Full Service Pack 1 (2)

I need the full Service Pack 1 (or 2) MSDE Installation files to include in an Installer. I am not interested in upgrading current MSDE RTM installs but rather need to install an MSDE SP1 (2) Instance on the client machines. I found a lot of places to get the files but the weird thing is in the supposed MSDE SP2 download files (SQL2KDeskSP2.exe) the sample.msi and samplupgr.msi files are missing that are the templates to be used to create the unique (GUID) MSI installation files for MSDE. Microsoft highly recommends creating the unique MSI files to ensure a previous instance did not use an MSI file with the same GUID.

see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp

The SQL2KDeskSP2.exe does include the SQLRUN01.MSI SQLRUN16.MSI files, but nowhere does it say you can use one of these files as a template and change the GUID internally using ORCA and VC++.

Are we supposed to use the old sample and sampleupg.msi files with SP2 .. but use all the other Install files for SP 1 (2) ?

Please excuse my ignorance of the "Windows Installer" software.

Thanks very much for any information,
Billy MatlockI have been able to get the full sql server sp1 files using msdn subscriber download. I think you have to order a cd if you do not have an msdn subscription.

I have not found a full desktop download for sp2 - although the page that announced the availability of sp2 implied that it would be in the subscriber downloads and that was a while ago.

MSDE

Hi
Trying to install Microsoft SQL Server 2000 Service Pack 4 on Win XP machine.
MSDE 2000 Sp3 already installed on D: drive, instance name= db1
In enterprise manager the db appears as ABC-111\DB1
ABC-111 is the name of the machine
I am using mixed authentication mode.
After reading the help I came up with this to install sp4:
setup /upgradesp sqlrun instancename="db1" securitymode=sql upgradeuser=sa
upgradepwd=sapw /L*v C:\MSDELog.log
I have also tried having instancename="ABC-111\DB1" but always the same error:
This product is not installed. Check is a appropriate instance of MSDE is
installed.
Now, note that the MSDE is installed here on my machine:
D:\Program Files\MSDE\MSSQL$DB1
Could that possible affect this?
I noticed when I looked in the registry that I did not find what the readme
file described, still, the database has been running smoothly for months...
Any hints somebody?
gst Valgar wrote:
> Hi
> Trying to install Microsoft SQL Server 2000 Service Pack 4 on Win XP
> machine. MSDE 2000 Sp3 already installed on D: drive, instance name=
> db1
> In enterprise manager the db appears as ABC-111\DB1
> ABC-111 is the name of the machine
> I am using mixed authentication mode.
> After reading the help I came up with this to install sp4:
> --
> setup /upgradesp sqlrun instancename="db1" securitymode=sql
> upgradeuser=sa upgradepwd=sapw /L*v C:\MSDELog.log
try setup /upgradesp sqlrun instancename=db1 securitymode=sql upgradeuser=sa
upgradepwd=sapw /L*v C:\MSDELog.log
without quotes...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||The error pervails...
"Andrea Montanari" wrote:

> ágúst Valgare wrote:
> try setup /upgradesp sqlrun instancename=db1 securitymode=sql upgradeuser=sa
> upgradepwd=sapw /L*v C:\MSDELog.log
> without quotes...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Sorry, my mistake, this seems to work, thank you!
"ágúst Valgare" wrote:
[vbcol=seagreen]
> The error pervails...
> "Andrea Montanari" wrote: