Failed To Upgrade MSDE2000 SP3a To SP4

Hi,

Recently when i try to upgrade my current MSDE 2000 (SP3a) to SP4, the system just keep on failing me. Here is the scenario:

1. Download the MSDE2000 SP4 from microsoft

2. Extract the SP4

3. Run the following command in either the command prompt or via a batch file:

echo off
echo "Start to Upgrade MSDE SP4 ... "
setup.exe /UPGRADESP SQLRUN INSTANCENAME=JSNG SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=Th3B3st /L*v c:MSDE_Log.log
echo "SP4 Upgrade Process completed!"

4. Once the above batch file was runned, the standard SQL configuration screen (gathering information) will be triggered.

5. However after a while the installation will just stopped.

6. When i checked on the log, i have found out that the failure of installation is due to the system has failed to configure the server. PFB for the last few rows of the verbose log:

=== Logging stopped: 8/22/2006 17:36:49 ===
MSI (c) (90:88) [17:36:49:865]: Note: 1: 1729
MSI (c) (90:88) [17:36:49:865]: Product: Microsoft SQL Server Desktop Engine -- Configuration failed.

MSI (c) (90:88) [17:36:49:865]: Grabbed execution mutex.
MSI (c) (90:88) [17:36:49:865]: Cleaning up uninstalled install packages, if any exist
MSI (c) (90:88) [17:36:49:865]: MainEngineThread is returning 1603
=== Verbose logging stopped: 8/22/2006 17:36:49 ===

7. When i check the MSI Installer Event ID at Microsoft site, it just said that this is the server configuration problem and i cant find any solution.

Any forumers here experience the above before? Mind to share some thoughts?

FYI, my current MSDE configuration is as follow:

- MSDE 2000 Release A (SP3a - 8.00.760)

- Installed Instance = JSNG



Thanks.

regards,

JS