Request for help on SQL Upgrade
KeithM
I have been attempting to install SP4 for SQL 2000 MSDE onto a server.
The downloaded file I have is SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
and its associated readme ReadmeSql2k32desksp4.htm
The Server itself is running Windows 2003 SP3 (Windows NT5.2 (3790)).
The instance of SQL I am trying to upgrade is called MSSQL$BKUPEXEC and was
installed as part of the installation of Symantec Backup Exec (originally
Version 10 but recently upgraded to 10.d Hotfix 6). SQL Enterprise Manager
tells me that this is at Version 8.00.760 (SP3). It is running on an Intel
X86 Platform with 4GB or RAM and 4 processors.
Following the readme and several postings I have been using the following
command line whilst logged on as a Domain Administrator
setup /upgradesp sqlrun INSTANCENAME=BKUPEXEC L*v C:\MSDE.log
The installer only runs for a minute before failing.
The content of the MSDE.log ends with
=== Logging stopped: 07/07/2010 14:55:12 ===
MSI (c) (6C:C4) [14:55:12:796]: Note: 1: 1729
MSI (c) (6C:C4) [14:55:12:796]: Product: Microsoft SQL Server Desktop Engine
-- Configuration failed.
MSI (c) (6C:C4) [14:55:12:812]: Grabbed execution mutex.
MSI (c) (6C:C4) [14:55:12:812]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (6C:C4) [14:55:12:812]: MainEngineThread is returning 1602
=== Verbose logging stopped: 07/07/2010 14:55:12 ===
(This log file contains no "Return Value 3" instances which I did see posted
as a suggested indication of failures. It does have some "Return Value 2" and
"Return Value 1"instances)
From this I believe I have a problem with SQL rather than Symantec. I also
note the presence of the following two Events in the Application event log
associated (in time) with the attempted installation:
Event ID 1015 Source MsiInstaller "Failed to connect to Server Error
0x800401F0"
and
Event ID 11729 Source MsiInstaller "Product Microsoft SQL Server Desktop
Engine - Configuration Failed".
Using the exact same command line I did achieve a successful installation on
another Server (also Running 2003 but SP1). this machine is not on the same
domain, in fact it is not on a domain. As far as I know the installation of
the Symantec Backup Exec is the same on this machine.
The goal of this exercise was to install MS09-004, which I believe requires
SQL SP4 as a prerequisite.
I have run out of ideas so any additional help would be appreciated.
Thanks.