MSDE 2000 SP4 update on Server failing with invalid Instance that has 4 instances on it

dpcsit
dpcsit used Ask the Experts™
on
Have a strange bird that needs a SP4 install. Currently there are two 2005 database and two 2000 databases on the server. When I look through the servers for SQL listings I have the following:

MSSQL$AWC
MSSQL$MIP

SQL Server (AWCEXPRESS)
SQL Server (SQLEXPRESS)

SQLAgent$AWC
SQLAgent$MIP

I was told that the AWC instance for 2000 was old and not in use but I was going to use it to test the SP4 update before trying MIP that actually needs the update.

I ran the following command SETUP INSTANCENAME="AWC" SAPWD="A_STRONG_PASSWORD" /L*v to a logfile

When I execute the command I get an Invalid Instance however I have selected the Instance in the AWC database and it is AWC.

I am stumped and figure it is perhaps confusing another instance somehow.

I am using SQL2000.MSDE-KB884525-SP4-X86-ENU.EXE.

I accidentally ran the command using the SQLAgent$AWC and it installed a blank instance so it appears to be the correct download.

I am stumped, please help!

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Instance name shouldn't be "AWCEXPRESS"?
AWC instance isn't SQL Server 2005?

Author

Commented:
ACW and MIP are both 2000 MSDE desktop instances, the ACWEXPRESS and SQLEXPRESS are 2005 I believe. The update I am attempting to install is the SP4 for the MSDE that is what is failing.

I was attempting to upgrade ACW but it fails with an invalid instance.

ACW reports back the following for version:
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 2)

MIP reports back the following for version:
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 2)

ACWEXPRESS reports back the following for version:
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Express Edition with Advanced Services on Windows NT 5.2 (Build 3790: Service Pack 2)
SQLEXPRESS reports back the following for version:
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Hope this clears my question up!
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Yes it's clear now for me. Thanks.
Did you read this article?: http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32desksp4.htm#_planning_upgrades_to_msde_2000_sp4_d3jb
Check for point 1.2.1

Other think you can do is uninstall current instance of MSDE and install new one with this one that came with SP4, giving the same name as old one.

Good luck
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
AWC instance says it ran the f:\MSDE2000\Setup\SQLRun02.msi file to install

MIP says f:\MSDE2000\Setup\SQLRun01.msi

Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:

Author

Commented:
I tried the following setup /upgradesp sqlrun INSTANCENAME="AWC ...

and get a This Product is not installed?!?!
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Yes it's weird.
What you think about uninstalling and reinstall again?

Author

Commented:
I think I wish I was a SQL expert LOL!
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
LOL
Really, I think you should do that (uninstall and install again).

Good luck

Author

Commented:
I have one more small puzzle piece I missed before, there is a SAGE install that I connected to that is SQL 2000 Server version 8.0.0.2039 or SQL Server 2000 SP4.

Now I wonder if that install might be mucking up the MSDE SP3 to SP4 updates?

Author

Commented:
Where can I find proper methods for backing up the databases and then uninstalling and reinstalling them? Can they be moved to a 2008 64 bit server that has sql 2005 on it?
IT Engineer
Distinguished Expert 2017
Commented:
For moving databases you just need to detach them, copy the files to the new location and attach them there.

Author

Commented:
We ended up detaching and deleting the old 2000 entry and adding back a 2005 express and reattaching the database, thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial