August 23, 2006 at 2:33 am
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
August 24, 2006 at 12:27 am
MSDE 2000 sp4 is a set of tools for a developer to use to create an update.
See section 1.2.1:
You must 1st determine if your installation type supports sp4:
http://support.microsoft.com/?kbid=311762
Next you will experiment until you get the proper command line or INI file configuration until the sp4 installs without error.
Unfortunately this is a "roll your own" situation, that most will skip as too hard to figure out for a one off update.
Andy
August 24, 2006 at 12:45 am
Hi Andy,
Thanks for your advice.
I have checked on the same article and its confirmed that i am using msi3 for my previous installation, which makes it compliant to SP4 upgrade.
The script that i have writen is based on the same readme article, and it just doesnt work and i have tried the same in both a windows XP Pro - SP2 machine and a windows 2003 server.
Did you manage to upgrade your MSDE 2000 SP3a to SP4 successfully? Do you think my script that i have posted before have any problem?
At the same time i have done some extra testing in one of the windows 2003 server where i have managed to upgrade SQL 2000 Server SP3 to SP4.
regards,
JS
August 24, 2006 at 6:35 am
I too had this problem once before. Eventually after working with MS support for 3 weeks and having them change the SQLRun01.MSI for me I was able to get an error that actually meant something. It apparently was caused by a "known SQL bug" but they didn't tell me which one.
They had me change my SQL Server and SQL Agent Services to local system and run the install and I was able to with no issues. I then changed my services back to using the proper user and all was well.
August 25, 2006 at 12:41 am
Hi Luke,
Thanks for sharing ... btw may i know how you change your SQL Server and SQL Agent Services to local system? Currently both services have been configured to log on as Local System Accont.
regards,
JS
August 25, 2006 at 6:08 am
January 25, 2008 at 3:40 pm
MIne was set to local and I am getting that error message "MainEngineThread is returning 1603" when trying to upgrade to SP4 MSDE.
I was able to install it on my application server wtih no problems but cannot install it on my database server.
Does anyone have any ideas of how to get it running.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply