Hello --
I downloaded and installed
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
These 4 SQL queries in Query analyzer indicate that I still am at SP3
SELECT SERVERPROPERTY('ProductLevel')
SELECT @@VERSION
SELECT SERVERPROPERTY('ProductVersion')
SELECT SERVERPROPERTY('Edition')
I know there are many variables involved in the upgrade (command line
parameters, etc.).
Does anyone have an idea of why the install might fail?
At the end of 2939 lines of msdelog.log is the following:
=== Logging stopped: 8/27/2005 22:21:45 ===
MSI (c) (EC:AC): Note: 1: 1729
MSI (c) (EC:AC): Product: Microsoft SQL Server Desktop Engine --
Configuration failed.
MSI (c) (EC:AC): Grabbed execution mutex.
MSI (c) (EC:AC): Cleaning up uninstalled install packages, if any exist
MSI (c) (EC:AC): MainEngineThread is returning 1603
=== Verbose logging stopped: 8/27/2005 22:21:45 ===
Is this of any help in determining what went wrong?
Thanks for any help.
Larry Mehl
Andrea Montanari - 29 Aug 2005 16:07 GMT
hi Larry,
> Hello --
>
[quoted text clipped - 25 lines]
>
> Is this of any help in determining what went wrong?
please search the log file for
RETURN VALUE 3
entries... about 10/15 line before each entry some (sometime cryptic)
descricpion of the problem will be reported..
anyway... before retrying, please verify your pc has File and Printer
Sharing setting enabled and that the Server service is up and running...

Signature
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://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